+ Reply to Thread
Results 1 to 3 of 3

Mirroring a single table across worksheets

  1. #1
    Registered User
    Join Date
    05-21-2009
    Location
    san antonio, tx
    MS-Off Ver
    Excel 2003
    Posts
    9

    Mirroring a single table across worksheets

    Good morning,

    At the top of all of my worksheets is a table that calculates a lifter's 1 rep max and 5 rep max (G1:L5) based on changes made in the yellow cells. This table is the same on every worksheet. I would like it so that no matter what sheet I'm on, when a change is made in a yellow cell, the same change is also made on the same tables in the all other worksheets. I would like all the tables to mirror each other. As it is right now, if you make a change on one table, you have to manually make the same changes on all the tables in the other worksheets.

    So, instead of having 5 separate tables (one separate table on each of the 5 worksheets), have one single table that is mirrored across all 5 worksheets so that you only have to manipulate the table once to see the change across all the worksheets.

    I understand I could just have the tables in worksheets 2-5 mirror what's on the table in worksheet 1, but I dont want to have to switch to the 1st worksheet to make a change. I hope this make sense, lol.
    Attached Files Attached Files

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Mirroring a single table across worksheets

    Hello,

    there are probably more elegant ways to do this, but here's what I've come up with:

    Put this code into the Sheet Module for each of the five sheets
    Please Login or Register  to view this content.
    Right-click the sheet tab, select View Code and paste the code into the code window. Repeat for each sheet.

    cheers,

  3. #3
    Registered User
    Join Date
    05-21-2009
    Location
    san antonio, tx
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Mirroring a single table across worksheets

    Works like a charm. Thank you so much!!

+ 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