software

I have a summary worksheet. On this worksheet I have relocations and
startups. I will have two other worksheets one for start ups and one for
relocations. I want to add new projects to either the relo or start up
sheets and I want it to go automatically to the summary page. Can anyone
help?


I think this is right

=sheet1!a1

your sheet that you want to link the cell to is sheet 1 and a1 is the
cell that is being linked

that works for me

Hope I wrote it so you can understand--
jpoltor
------------------------------------------------------------------------
jpoltor's Profile: www.excelforum.com/member.php...oamp;userid=32596
View this thread: www.excelforum.com/showthread...hreadid=524122I want to type in something on the Summary sheet and I want the worksheet to
copy it to the Relo worksheet if it is a relo and to the start up worksheet
if it is a start up.

quot;jpoltorquot; wrote:

gt;
gt; I think this is right
gt;
gt; =sheet1!a1
gt;
gt; your sheet that you want to link the cell to is sheet 1 and a1 is the
gt; cell that is being linked
gt;
gt; that works for me
gt;
gt; Hope I wrote it so you can understand
gt;
gt;
gt; --
gt; jpoltor
gt; ------------------------------------------------------------------------
gt; jpoltor's Profile: www.excelforum.com/member.php...oamp;userid=32596
gt; View this thread: www.excelforum.com/showthread...hreadid=524122
gt;
gt;