Cell reference question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Relative worksheet reference clarified 4
modify all formula references in multiple cells 3
Cell reference between worksheets 4
worksheet cross reference 6
How to reference different worksheets in an autofill formula 8
Ref Formula 4
Copy/Paste Question 3
Reference worksheets in ascending order 1

Back
Top