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. |
=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. |
All times are GMT +1. The time now is 12:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com