- #Target twin set permanent press sheets how to
- #Target twin set permanent press sheets update
- #Target twin set permanent press sheets code
- #Target twin set permanent press sheets series
InStr(2, Range(sheetKeyPhraseCell).Offset(0, 1).Address(True, True), "$") - 1) 'so add 1 to that column number to get the first column # for the "B4", "D16" type entriesįirstColID = Left(Range(sheetKeyPhraseCell).Offset(0, 1).Address(True, True), _ 'assumes that the key phrase cell is directly above the first If InStr(UCase(Trim(anyPODSheet.Range(sheetKeyPhraseCell))), UCase(Trim(sheetKeyPhraseText))) = 1 ThenįirstPODRow = Range(sheetKeyPhraseCell).Row + 1 'this phrase must start at the left-most part of the entry 'that have the key phrase text ("POD ") in the key phrase cell (B3)įor Each anyPODSheet In ThisWorkbook.Worksheets 'work through all worksheets in the workbook, identifying those
#Target twin set permanent press sheets update
'level so we only update rows where it matches properly 'save the value of Target for comparison at the sheet 'did did (all of) the change(s) take place in the proper row? 'prior to the call the variables declared above 'once for each sheet that needs to be processed Private Sub Worksheet_Change(ByVal Target As Range) 'this holds the value of 'Target' from the Start Worksheet_Change() event 'this will be the letter ID of the last column on the 'sheet with a 'B4', C6, D11, E7, etc type entry in it 'This will be the letter ID of the first column on the 'or to all be the same, but user doesn't have to track it. 'sheet to have a different number of entries (used rows) 'the sheet itself, allowing for any given 'the last row will be determined at run time 'this will be the first row to examine for ' define any given sheet that must be processed ' Worksheet_Change() event process as needed to 'Example: 1st is C, next is F, so 6-3 = 3 'columns with 'B4', C6, D11, E7, etc type entries in them 'this will be the number of columns between the ' being used and include enough characters to uniquelyĬonst sheetKeyPhraseText = "POD " ' 1st 4 characters are always "POD " ' You must start at the left side of whatever phrase is ' ensure accurate identification of cell B3
' enough of the "POD ix of X" type entries to ' where to find the "POD ix of X" type entries ' this is the row on the Start sheet where the values we 'in case other sheets besides the 'Start' and "t_#" type sheets
#Target twin set permanent press sheets how to
'and how to determine that it is a "t_#" type sheet 'how things are laid out on the "t_#" type sheets,
#Target twin set permanent press sheets code
'the code can determine where the values on Start are that 'these constant values 'define' the different sheets so that The code was all placed in the code module for the one sheet where the changes are initiated (by changing a value The specific layout of those can change in terms of number of columns/rows used, but each follows the same general layout. The number of the "other" sheets is variable andĬan change over time.
#Target twin set permanent press sheets series
The basic issue was to identify specific cells that changed on a series of worksheets in the workbook in response to changes in cells on one other worksheet. The final solution to this is provided below. Tables of Numbers but with different increments in them.Īnd please don't tell me, copy and paste the Values so they will become as a permanent text, That is to much work with a workbook that could contain from 37 spreadsheets up to 70 spreadsheets, I need a function for that, or I will accept a VBA solution as well. The values on this spreadsheet are conditional and they change on a daily base, and the resin that I need a "Function" is that this workbook can contain from 37 spreadsheets up to 70 spreadsheets, that most of them almost have the same or some what different if cell K4 is highlighted or cell L4 shows a value(cell L4 is a result of K4), I need a cell next to them that counts how many time ether of them comes up.
a permanent value as "1", even if cell K4 will not be highlighted and cell L4 will not show a value(cell L4 is a result of K4).Ģ. Now, every time that column L or M or N will show a value, I need a cell next to it on the same row to show, ether or:ġ. If you look at the attachment on this massage, you will see a part of a spreadsheet. Or if there is a different solution to my problem, I will be more then happy to get help.
I need help with a spreadsheet, I need to make a cell value permanent.
0 kommentar(er)
