+ Reply to Thread
Results 1 to 8 of 8

Mirroring 2 Tables in 2 sheets

  1. 04-22-2022, 09:48 AM #1
    BassemCh
    BassemCh is offline
    Registered User
    Join Date
    12-17-2020
    Location
    London
    MS-Off Ver
    2010
    Posts
    64

    Exclamation Mirroring 2 Tables in 2 sheets

    I want to mirror 2 tables in 2 sheets in the same workbook, I tried to link the cells which works fine, but what i want to do is more advanced.
    Like when I delete a row in the source table I need the destination table to remove that row as well. and when I add a row in the source table I want that row to be added as well.

    The source have employees names and IDs, the destination table have Names and IDs and more columns like work shifts and dates .


    so I'm looking more to have a 100% exact mirroring of those tables.

    Hope anyone can help
    Attached Files Attached Files
    Last edited by BassemCh; 04-27-2022 at 10:17 AM.
    Reply With QuoteRegister To Reply
  2. 04-22-2022, 10:37 AM #2
    PeteABC123
    PeteABC123 is offline
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365 ver 2202
    Posts
    1,104

    Re: Mirroring 2 Tables in 2 sheets

    Hi BassemCh:

    Try this to get you started:
    Highlight the all employees source data including headings.
    Then go to: Data. Get and transform data from table or range.
    Close and Load. Close and load to. . .
    It'll show up on a new worksheet.
    Add your desired additional column labels.
    Test your results by adding or removing rows and their records from the source table.
    Go back to your results table, right click on it, click refresh.

    Pete
    Reply With QuoteRegister To Reply
  3. 04-22-2022, 10:50 AM #3
    BassemCh
    BassemCh is offline
    Registered User
    Join Date
    12-17-2020
    Location
    London
    MS-Off Ver
    2010
    Posts
    64

    Re: Mirroring 2 Tables in 2 sheets

    That's smart! Amazing!

    Thanks a lot for your help @PeteABC123
    Reply With QuoteRegister To Reply
  4. 04-27-2022, 10:21 AM #4
    BassemCh
    BassemCh is offline
    Registered User
    Join Date
    12-17-2020
    Location
    London
    MS-Off Ver
    2010
    Posts
    64

    Re: Mirroring 2 Tables in 2 sheets

    Hello @PeteABC123

    I just noticed that if I filter out some rows in the query table, the rows in the added columns do not match with the rows in the query anymore!

    what's the best way to keep all rows in the added columns matching with the rows in the query table?
    That's a big problem if they do not match!

    any idea?
    Thanks
    Reply With QuoteRegister To Reply
  5. 04-27-2022, 10:43 AM #5
    PeteABC123
    PeteABC123 is offline
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365 ver 2202
    Posts
    1,104

    Re: Mirroring 2 Tables in 2 sheets

    Bummer BassemCh. :-(

    Perhaps using formulas to reconnect with result data?
    Reply With QuoteRegister To Reply
  6. 04-27-2022, 11:02 AM #6
    BassemCh
    BassemCh is offline
    Registered User
    Join Date
    12-17-2020
    Location
    London
    MS-Off Ver
    2010
    Posts
    64

    Re: Mirroring 2 Tables in 2 sheets

    Yes! but what type of formulas?

    Maybe if I can link tables with an ID field in both tables?
    Reply With QuoteRegister To Reply
  7. 04-27-2022, 12:32 PM #7
    PeteABC123
    PeteABC123 is offline
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365 ver 2202
    Posts
    1,104

    Re: Mirroring 2 Tables in 2 sheets

    Hi BassemCh. I suppose it depends on your data and how it's layed out. vlookup could do it.
    If the ID field is consistent between tables then you might be on to something.
    Reply With QuoteRegister To Reply
  8. 04-27-2022, 01:17 PM #8
    BassemCh
    BassemCh is offline
    Registered User
    Join Date
    12-17-2020
    Location
    London
    MS-Off Ver
    2010
    Posts
    64

    Re: Mirroring 2 Tables in 2 sheets

    Yes I will try that! and let you know.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Mirroring sheets, filtering, and getting Error 424
    By rockoxide in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-07-2020, 06:54 AM
  2. Cell Mirroring
    By skmerrey in forum Excel General
    Replies: 5
    Last Post: 07-24-2019, 09:37 AM
  3. Mirroring multiple cells on different sheets
    By helen269 in forum Excel General
    Replies: 2
    Last Post: 12-12-2018, 02:30 PM
  4. VBA Code for mirroring data bidirectionally from master sheet to child sheets
    By chandhana21 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-11-2017, 08:54 PM
  5. [SOLVED] Mirroring entries from multiple sheets to one sheet
    By LSD25 in forum Excel General
    Replies: 3
    Last Post: 02-22-2017, 09:35 PM
  6. Sheet mirroring: keyword filtered mirroring from sheet 1 to sheet 2
    By Choffe in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-07-2013, 08:02 AM
  7. Pivot Tables - need to do separate pivot tables for multiple sheets in same format
    By tconnell1965 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2013, 07:04 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1