Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
Here's my situation: I have a workbook in which I'd like to reference a cell in another worksheet, but would like to increment the reference as I move down rows in the original worksheet. For example, on Worksheet 1, cell A1 contains "=Worksheet2!A192". In cell A2, I would like to reference "=A1 + [whatever I'd put in here that would result in the reference actually being "=Worksheet2!A196"]" The whole point is to be able to copy the cell down without having to go in and enter the exact references manually. Hope this makes sense... Thanks! Stefan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
Using a cell reference to refernce worksheet in another work book | Excel Worksheet Functions | |||
Indirect reference from one worksheet to another | Excel Worksheet Functions | |||
interchange columns with rows | Excel Discussion (Misc queries) | |||
Reference Data in Moved Worksheet | Setting up and Configuration of Excel |