Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can an incrementing value in a cell point to different worksheets?
I want to increment a value in a cell formula to refer to sequential
worksheets. i.e. - my worksheets may be labeled 1,2,3,4,5,... etc. I want to use a formula that will cause a cell in each row to refer to the next worksheet . i.e. - as the row number increases, I want the worksheet reference in the cell formula to increment and thus get its data from a different worksheet. Is this possible? Any help would be appreciated. -- sdm |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can an incrementing value in a cell point to differentworksheets?
You can use the INDIRECT function for this. Essentially, you create
the cell reference as a string and use this in the function to get data from that cell. Unfortunately your description is a bit vague, so I can't recommend a specific formula to you - perhaps you can post back with some details of the cells/columns you use. Hope this helps. Pete On Jan 29, 5:29*pm, sdm wrote: I want to increment a value in a cell formula *to refer to sequential worksheets. i.e. - my worksheets may be labeled 1,2,3,4,5,... etc. I want to use a formula that will cause a cell in each row to refer to the next worksheet . i.e. - as the row number increases, I want the worksheet reference in the cell formula to increment and thus get its data from a different worksheet. Is this possible? Any help would be appreciated. -- sdm |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can an incrementing value in a cell point to different worksheets?
Use =INDIRECT()
=INDIRECT(ROWS($1:1) & "!A33") and copy down. The sheet number will increment and not the cell address. This will only work if the sheets actually are named 1,2,3,4,... -- Gary''s Student - gsnu200829 "sdm" wrote: I want to increment a value in a cell formula to refer to sequential worksheets. i.e. - my worksheets may be labeled 1,2,3,4,5,... etc. I want to use a formula that will cause a cell in each row to refer to the next worksheet . i.e. - as the row number increases, I want the worksheet reference in the cell formula to increment and thus get its data from a different worksheet. Is this possible? Any help would be appreciated. -- sdm |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can an incrementing value in a cell point to different workshe
The INDIRECT() formula was just what I was looking for.
Thanks a ton. -- sdm "Gary''s Student" wrote: Use =INDIRECT() =INDIRECT(ROWS($1:1) & "!A33") and copy down. The sheet number will increment and not the cell address. This will only work if the sheets actually are named 1,2,3,4,... -- Gary''s Student - gsnu200829 "sdm" wrote: I want to increment a value in a cell formula to refer to sequential worksheets. i.e. - my worksheets may be labeled 1,2,3,4,5,... etc. I want to use a formula that will cause a cell in each row to refer to the next worksheet . i.e. - as the row number increases, I want the worksheet reference in the cell formula to increment and thus get its data from a different worksheet. Is this possible? Any help would be appreciated. -- sdm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Incrementing cell addresses | Excel Worksheet Functions | |||
Incrementing cell reference | Excel Discussion (Misc queries) | |||
Dragging & incrementing cell values | Excel Worksheet Functions | |||
incrementing mm/yy based on value in other cell | Excel Worksheet Functions | |||
Incrementing Cell Numbers | Excel Discussion (Misc queries) |