Cell Reference Change
 

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
------------------------------------------------------------------------
MDW's Profile: http://www.excelforum.com/member.php...o&userid=32769
View this thread: http://www.excelforum.com/showthread...hreadid=526018

Cell Reference Change
 

so the formula in sheet 2 should look like this =Sheet1!$A$1
and no metter how many rows you will insert in sheet 2 you`ll get the value from sheet1 cell A1

--
M.A.
"MDW" wrote in message ...


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
------------------------------------------------------------------------
MDW's Profile: http://www.excelforum.com/member.php...o&userid=32769
View this thread: http://www.excelforum.com/showthread...hreadid=526018

Cell Reference Change
 

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

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


--
MDW
------------------------------------------------------------------------
MDW's Profile: http://www.excelforum.com/member.php...o&userid=32769
View this thread: http://www.excelforum.com/showthread...hreadid=526018

Cell Reference Change
 

I believe you want Indirect. Like this maybe:

=INDIRECT("'sheet2'!a1")

--
Kevin Vaughn


"MDW" wrote:


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
------------------------------------------------------------------------
MDW's Profile: http://www.excelforum.com/member.php...o&userid=32769
View this thread: http://www.excelforum.com/showthread...hreadid=526018

Cell Reference Change
 

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.


--
MDW
------------------------------------------------------------------------
MDW's Profile: http://www.excelforum.com/member.php...o&userid=32769
View this thread: http://www.excelforum.com/showthread...hreadid=526018

Cell Reference Change
 

Kevin,

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

:cool:


--
MDW
------------------------------------------------------------------------
MDW's Profile: http://www.excelforum.com/member.php...o&userid=32769
View this thread: http://www.excelforum.com/showthread...hreadid=526018

Cell Reference Change
 

You're welcome.
--
Kevin Vaughn


"MDW" wrote:


Kevin,

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

:cool:


--
MDW
------------------------------------------------------------------------
MDW's Profile: http://www.excelforum.com/member.php...o&userid=32769
View this thread: http://www.excelforum.com/showthread...hreadid=526018