Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Set up a formala to refer to a cell in a different sheet
I need to set up a formula in one sheet to appertain to a cell in another
sheet(same row, different column) that can be dragged and copied down a column. I have found that =INDIRECT("'"&$D$19&"'!b"&ROW()) , where D19 is the name of sheet 2, does what I want as long as I don't insert a new row in sheet 1. However, whenever I insert a new row in sheet one, all of the information is thrown off. Can I somehow lock the rest of the column against the information listed in column A, (for example A23 is account number, B23-G23 is other info related to that account), but still have a formula that can be copied without using a VBA macro?? If so, how? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum of 3 nos. into 1 cell in another sheet relevant to specific da | Excel Discussion (Misc queries) | |||
Refer new sheet to previous sheet | Excel Worksheet Functions | |||
Refer to sheet name specified in other cell | Excel Discussion (Misc queries) | |||
Copy text from same cell on every sheet to title sheet? | Excel Discussion (Misc queries) | |||
Need formula for sheet & cell reference | Excel Worksheet Functions |