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