+ Reply to Thread
Results 1 to 3 of 3

multiple worksheets all update when a change is made to column a in master worksheet

  1. #1
    Registered User
    Join Date
    04-02-2013
    Location
    Ny, USA
    MS-Off Ver
    Excel 2010
    Posts
    2

    multiple worksheets all update when a change is made to column a in master worksheet

    Is it possible to set up multiple workshhets that all share the same Rows.
    I am looking to create a "master" worksheet and several additional worksheets that would share the same setup as the master.
    I want to be able to add additional rows to the master and have the row additions update in the additional worksheets.
    Is this possible?
    Thanks

  2. #2
    Valued Forum Contributor
    Join Date
    03-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007/10/16
    Posts
    840

    Re: multiple worksheets all update when a change is made to column a in master worksheet

    Hi

    Welcome to the forum.
    Please look at the file.
    Is this what you looking for?
    Attached Files Attached Files
    To help you by my post? it would be nice to click on to say "Thank you".
    If you are happy with a solution to your problem?
    Click Thread Tools above your first post,
    select "Mark your thread as Solved".

  3. #3
    Registered User
    Join Date
    04-02-2013
    Location
    Ny, USA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: multiple worksheets all update when a change is made to column a in master worksheet

    Not quite what I am after.I want column A to be a list of names. columns b-f will be data.
    I want to mirror column A in a second and third spreadsheet. When I add a row for a new namw in the first spreadsheet, I would like the second and third to have the new row added also.
    Is this possible?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1