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