Same info from one column to different columns in multiple worksheets

B

B_K

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!!!
 
M

mrice

If you put a formula into cell A1 in sheet 2

=Sheet1!A1

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

B_K

I've tried pasting this formula in sheet 2, it works for getting th
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 an
way that when I insert/delete a row in sheet 1, the same changes wil
be made automatically in the other sheets
 
R

Ronco

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

B_K

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!
 
R

Ronco

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