Auto updating across multiple worksheets

steveO · Apr 9th, 2002, 02:46 PM

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 · Apr 9th, 2002, 02:59 PM

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 · Apr 9th, 2002, 03:09 PM

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

Quote:

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 · Apr 9th, 2002, 03:24 PM

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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 02:46 PM	#1
steveO New Member Join Date: Apr 2002 Posts: 2	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??

Apr 9th, 2002, 02:59 PM	#2
EdE Board Regular Join Date: Apr 2002 Location: A Mile High!! Posts: 230	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

Apr 9th, 2002, 03:24 PM	#4
EdE Board Regular Join Date: Apr 2002 Location: A Mile High!! Posts: 230	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?