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.
--
Cassie

=INDIRECT("$A$17") will do it

"Cassie Rodgers" wrote:

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.
--
Cassie

Does this work if the cell I need referenced is on a different worksheet?
--
Cassie


"Sean Timmons" wrote:

=INDIRECT("$A$17") will do it

"Cassie Rodgers" wrote:

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.
--
Cassie

Thanks much! It worked!
--
Cassie


"Sean Timmons" wrote:

=INDIRECT("$A$17") will do it

"Cassie Rodgers" wrote:

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.
--
Cassie

=INDIRECT("Sheet1!"&"$A$17")


Gord Dibben MS Excel MVP

On Fri, 23 Oct 2009 11:00:01 -0700, Cassie Rodgers
wrote:

Does this work if the cell I need referenced is on a different worksheet?