Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Auto updating across multiple worksheets

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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??

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Location
    A Mile High!!
    Posts
    241
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  4. #4
    Board Regular
    Join Date
    Apr 2002
    Location
    A Mile High!!
    Posts
    241
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •