software

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: www.excelforum.com/member.php...oamp;userid=32769
View this thread: www.excelforum.com/showthread...hreadid=526018so 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.
quot;MDWquot; gt; wrote in message ...
gt;
gt; I have constructed a document by laying out a template on worksheet 1
gt; and inputting info on worksheet 2. To input new information I insert a
gt; row however the corresponding formula cells on worksheet 1 change row
gt; number to follow the already inserted line. Protecting worksheet one
gt; does not work.
gt;
gt; I want to find a way to ensure that the values always apply to the same
gt; cell number on workshhet 2 i.e. cell =A1 always stays the same
gt; regardless of if I insert a line.
gt;
gt; Please help!!
gt;
gt;
gt; --
gt; MDW
gt; ------------------------------------------------------------------------
gt; MDW's Profile: www.excelforum.com/member.php...oamp;userid=32769
gt; View this thread: www.excelforum.com/showthread...hreadid=526018
gt;

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

Someone must be able to help..........please!!!--
MDW
------------------------------------------------------------------------
MDW's Profile: www.excelforum.com/member.php...oamp;userid=32769
View this thread: www.excelforum.com/showthread...hreadid=526018I believe you want Indirect. Like this maybe:

=INDIRECT(quot;'sheet2'!a1quot;)

--
Kevin Vaughnquot;MDWquot; wrote:

gt;
gt; I have constructed a document by laying out a template on worksheet 1
gt; and inputting info on worksheet 2. To input new information I insert a
gt; row however the corresponding formula cells on worksheet 1 change row
gt; number to follow the already inserted line. Protecting worksheet one
gt; does not work.
gt;
gt; I want to find a way to ensure that the values always apply to the same
gt; cell number on workshhet 2 i.e. cell =A1 always stays the same
gt; regardless of if I insert a line.
gt;
gt; Please help!!
gt;
gt;
gt; --
gt; MDW
gt; ------------------------------------------------------------------------
gt; MDW's Profile: www.excelforum.com/member.php...oamp;userid=32769
gt; View this thread: www.excelforum.com/showthread...hreadid=526018
gt;
gt;


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(quot;sheet2!a1quot;lt;0.001,quot; quot;,quot;sheet2!a1quot;)). Any idea how I get
around this problem?

Thanks again.--
MDW
------------------------------------------------------------------------
MDW's Profile: www.excelforum.com/member.php...oamp;userid=32769
View this thread: www.excelforum.com/showthread...hreadid=526018
Kevin,

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

--
MDW
------------------------------------------------------------------------
MDW's Profile: www.excelforum.com/member.php...oamp;userid=32769
View this thread: www.excelforum.com/showthread...hreadid=526018You're welcome.
--
Kevin Vaughnquot;MDWquot; wrote:

gt;
gt; Kevin,
gt;
gt; Thanks A whole bunch for your help. You are a star!!!!!
gt;
gt;
gt;
gt;
gt; --
gt; MDW
gt; ------------------------------------------------------------------------
gt; MDW's Profile: www.excelforum.com/member.php...oamp;userid=32769
gt; View this thread: www.excelforum.com/showthread...hreadid=526018
gt;
gt;