Linking one sheet to another

M

Mad Dog

I have quite a bit of data to enter in precisely the same spot in two
worksheets. I'd like to be able to link these two sheets together
(temporarily) so that what I'm entering in one sheet goes into the other at
the same cell location. Is this possible in Excel?
 
N

Nick

Hold the Ctrl key and select the Tabs for each worksheet that you want to be
affected.
This will group teh worksheets. Then if you enter 50 in cell A1 of any of
the selected sheets it will also enter 50 in A1 of all the other sheets.

Nick
 
L

Linking two Excel worksheets

This didn't work for me. Is there another step to follow after holding the
ctrol key and selecting the tabs for each worksheet? I want to link only 2
worksheets, the second worksheet is a copy of the first. To this I have to
add data that I don't want in the first sheet. However, worksheet 2 must
pick up changes in worksheet 1!

What am I doing wrong?
 
D

Dave Peterson

The method of selecting multiple sheets is a way to do data entry to all the
selected worksheets at the same time.

If you ungroup the worksheets (to get back to normal), then any further changes
won't go to the other sheets.

But it sounds like you could use a formula:

=sheet1!a1
will link that cell back to sheet1, cell A1.

Maybe better if sheet1!a1 could be empty:

=if(sheet1!a1="","",sheet1!a1)
 
Top