How do I link worksheets

[Stephanie B]

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?

[jpoltor]

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

[Stephanie B]

I 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.

"jpoltor" wrote:

>
> 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: http://www.excelforum.com/member.php...o&userid=32596
> View this thread: http://www.excelforum.com/showthread...hreadid=524122
>
>