Results 1 to 2 of 2

Thread: Mirroring multiple sheets - consolidated table

  1. #1
    Neophyte zilbero's Avatar
    Join Date
    Nov 2018
    Excel Version

    Mirroring multiple sheets - consolidated table

    Register for a FREE account, and/
    or Log in to avoid these ads!


    I'm managing a Work plan in an Excel file, with separate sheets per the product segmentation.
    I was asked to also present a consolidated sheet displaying all activities so that the overall activities would be presented from older to newer due dates.

    I first converted the data into Table and then I used 'Data--> From other Sources --> From Microsoft Query'
    I repeated it for the various product-specific sheets.
    I have 2 main problems with the result and for which i'm looking for your support:
    1. The Header row ( I have the same header for all separate sheets)for each of the Tables I created in the separate Sheets appear multiple times.
      I tried hiding these rows but if the source data is updated and new rows are added, the 'hide' simply applies for a different row and not the header row.
    2. When I sort the data from Oldest to Newest it applies only to each table separately and doesn't sort the entire workbook.

    I'd really appreciate a solution as I couldn't find one in various forums/google.


  2. #2
    Conjurer alansidman's Avatar
    Join Date
    Oct 2018
    Steamboat Springs
    Excel Version
    I wonder if you might have greater success with Power Query to consolidate the sheets and then get the desired results.

Tags for this Thread

Posting Permissions

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