Auto updating across multiple worksheets

[steveO]

I've got a need to keep two worksheets in-sync. One worksheet acts as a master containing all relevant customer data and the second worksheet is a subset of the master containing the customer's mailing info. Any additions / deletions / updates to the master would need to flow thru to the mailer. Any ideas??

 

[EdE]

Steve -

Are you just needing to basically update the sheet by opening it then saving it?

I do this to a point as I have one master and about 20 sub sheets.

EdE

 

[steveO]

EdE,

Thanks for your reply!

I want to be able to make additions / changes / deletions the master only and have those changes automatically show up on the mailer, if applicable. If I add a row to the master, that row should show up on the mailer. If I delete a row in the master, the corresponding row in the mailer should also be deleted. If I make a change to mailing info in the master, those changes should be reflected in the mailer.

Hope this helps!

Steve

On 2002-04-09 13:59, EdE wrote:
Steve -

Are you just needing to basically update the sheet by opening it then saving it?

I do this to a point as I have one master and about 20 sub sheets.

EdE

 

[EdE]

No problem. Just link all the information that you want to change automatically to the sub sheet. However, if you want to delete/add rows to the master and want that to reflect in the sub, you will need both sheets open. On my sheets, I have lots of links but instead of using cell ranges, I have named the cells and/or ranges. That way if you dont have the sub open, it will be able to find the information. Do you know how to name cells and ranges and link information?