Hello,

I have an Excel file with 5 worksheets in it. In worksheet 1, the
first column contains a list of names. Basically, in the other 4
worksheets, I want the first columns to contain the same list of names
from worksheet 1.

So in the future, if I make changes to the name list in worksheet 1,
the changes will be automatically applied to the name list in the other
4 worksheets.

Also, there are empty cells in the first column (the name list) too.

How can I do this?

Please help! Thanks!!!


--
B_K
------------------------------------------------------------------------
B_K's Profile: http://www.excelforum.com/member.php...o&userid=33874
View this thread: http://www.excelforum.com/showthread...hreadid=536535

If you put a formula into cell A1 in sheet 2

=Sheet1!A1

and copy down, you will get the linking that you need.


--
mrice

Reserach Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=536535

I've tried pasting this formula in sheet 2, it works for getting the
links of existing cells; however, if I try to insert a row in sheet 1,
I'll have to insert a row manually in sheet 2 myself. So is there any
way that when I insert/delete a row in sheet 1, the same changes will
be made automatically in the other sheets?


--
B_K
------------------------------------------------------------------------
B_K's Profile: http://www.excelforum.com/member.php...o&userid=33874
View this thread: http://www.excelforum.com/showthread...hreadid=536535

To make the same change on multiple sheets, select the sheets you want to
change, either by using the Ctrl or Shift keys or by right-clicking a tab and
Select All Sheets. Now, when you make a change to sheet 2 it will also
change the other sheets. Caution: be sure to unselect after your changes or
everything you do will take affect on each sheet.

"B_K" wrote:


I've tried pasting this formula in sheet 2, it works for getting the
links of existing cells; however, if I try to insert a row in sheet 1,
I'll have to insert a row manually in sheet 2 myself. So is there any
way that when I insert/delete a row in sheet 1, the same changes will
be made automatically in the other sheets?


--
B_K
------------------------------------------------------------------------
B_K's Profile: http://www.excelforum.com/member.php...o&userid=33874
View this thread: http://www.excelforum.com/showthread...hreadid=536535

Thank you for all your replies!

Just one more question... when I paste the formula in the row with a
blank cell, a "0" appears in the cell... is there some ways to get rid
of the "0"?

I know I can just skip that blank cell and not paste the formula in
there, but I want to paste the formula in the blank cells too for
consistency.

Thanks!


--
B_K
------------------------------------------------------------------------
B_K's Profile: http://www.excelforum.com/member.php...o&userid=33874
View this thread: http://www.excelforum.com/showthread...hreadid=536535

To not show 0 values: Tools, Options, View, and unselect Zero values (in the
middle near the bottom).

"B_K" wrote:


Thank you for all your replies!

Just one more question... when I paste the formula in the row with a
blank cell, a "0" appears in the cell... is there some ways to get rid
of the "0"?

I know I can just skip that blank cell and not paste the formula in
there, but I want to paste the formula in the blank cells too for
consistency.

Thanks!


--
B_K
------------------------------------------------------------------------
B_K's Profile: http://www.excelforum.com/member.php...o&userid=33874
View this thread: http://www.excelforum.com/showthread...hreadid=536535