Cell reference between worksheets


Cassie Rodgers

I have a spreadsheet that has multiple worksheets. The first worksheet is a
status tracking tool for the other worksheets which contain all the daily
detail. I want to be able to refernce specific cells in each worksheet and
have them populate the first worksheet with updated detail.

As I add new detail to the individual sheets, I insert a column so that the
most current detail is listed on the top. The detail I want to populate the
tracking worksheet is in cell A17 of the individual worksheets. I have tried
to reference it as an absolute value using $A$17. What happens is when I
insert a new row, it shows $A$18.

How do I get this to always reference A17? I've tried to name the cell but
that didnt work either.




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