Master Worksheet?

[skrop1]

I have a workbook with around thirty sheets that all contain the same data (names). How can I make a master worksheet so that when I change the data in that one sheet (change the list of names by adding or deleting) it will change in all the subsequent worksheets?

Thanks for your help!

Shannon

 

[Yogi Anand]

On 2002-05-06 11:54, skrop1 wrote:
I have a workbook with around thirty sheets that all contain the same data (names). How can I make a master worksheet so that when I change the data in that one sheet (change the list of names by adding or deleting) it will change in all the subsequent worksheets?

Thanks for your help!

Shannon

Select all worksheets including the master worksheet -- then when you make any change in the master worksheet, it will simultaneously be made in all the selected worksheets;

the other option would be to link the particular cell(s) reffs in the master worksheet to the other 30 sheets;

and then you may also do it using VBA

Regards!

Yogi Anand

 

[skrop1]

Thanks so much! You've made my life much easier!

-S