Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Master Worksheet?

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

    Default

    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

  2. #2
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

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

    Default

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

    -S

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
  •