Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cell reference question
I am trying to do a summary page to show specific fields on different
worksheets within my excel file. I understand how to show the field but my problem is when I insert a new row on the worksheets where the info is referenced from it pushes the field down one row and my summary page reference shows the new location of the original reference.. confusing I know. I am hoping someone can tell me how to make the formula always reference the same cell no matter how many rows/columns I insert. Thank you for any help. |
#2
|
|||
|
|||
=INDIRECT("Sheet1!A3")
will always point to A3 -- Regards, Peo Sjoblom "JM" wrote in message ... I am trying to do a summary page to show specific fields on different worksheets within my excel file. I understand how to show the field but my problem is when I insert a new row on the worksheets where the info is referenced from it pushes the field down one row and my summary page reference shows the new location of the original reference.. confusing I know. I am hoping someone can tell me how to make the formula always reference the same cell no matter how many rows/columns I insert. Thank you for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dynamic external cell reference | Excel Worksheet Functions | |||
Using a Text / Data output as a cell reference | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
name of another worksheet in cell for reference | Excel Worksheet Functions |