Cell Reference Change

[MDW]

I have constructed a document by laying out a template on worksheet 1
and inputting info on worksheet 2. To input new information I insert a
row however the corresponding formula cells on worksheet 1 change row
number to follow the already inserted line. Protecting worksheet one
does not work.

I want to find a way to ensure that the values always apply to the same
cell number on workshhet 2 i.e. cell =A1 always stays the same
regardless of if I insert a line.

Please help!!

 

[MDW]

Marijus.......is your response supose to be helpful?? You must work for
Microsoft!!??

Someone must be able to help..........please!!!

 

[Guest]

I believe you want Indirect. Like this maybe:

=INDIRECT("'sheet2'!a1")

 

[MDW]

Kevin Vaughn thanks for your reply. This issue has been driving me
crazy. This does solve my problem for the most part however using
INDIRECT has caused another problem. On several of the cells I do not
want a 0 to appear where a value is not detailed. I have tried the
following but it still shows a zero.

=INDIRECT(IF("sheet2!a1"<0.001," ","sheet2!a1")). Any idea how I get
around this problem?

Thanks again.

 

[Guest]

You could try this one:

=IF(INDIRECT("'sheet2'!a1")=0,"",INDIRECT("'sheet2'!a1"))

 

[MDW]

Kevin,

Thanks A whole bunch for your help. You are a star!!!!!

:cool

 

[Guest]

You're welcome.