+ Reply to Thread
Results 1 to 6 of 6

Consolidating multiple sheets in master tab and create summary sheet

  1. #1
    Registered User
    Join Date
    05-01-2012
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    40

    Consolidating multiple sheets in master tab and create summary sheet

    Hi There,
    I hope some one will help me.
    I have a worksheet with multiple tabs and keep adding every month with new tab.
    I would like to get all the records from all sheets to the master tab and create summary on summary tab. All the sheets have same headers but around 90+ columns and many rows.

    Also, I would like to create two buttons, 1-Reset and 2- Update on one tab if possible OR on 1st row of the master at A1 and B1

    Update button= to have all records from all the present sheets to the master

    Reset button = To clear all the update from master tab before clicking update again to avoid duplicate recording of all sheets which I encountered before

    The sample file is attached.
    Thanks
    Farida
    Attached Files Attached Files

  2. #2
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Consolidating multiple sheets in master tab and create summary sheet

    Hi Farida

    This Code in the attached will populate Master
    Please Login or Register  to view this content.
    And this Code in the attached will clear Master
    Please Login or Register  to view this content.
    I see no indication of what your requirements are for Summary Sheet.
    Attached Files Attached Files
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  3. #3
    Registered User
    Join Date
    05-01-2012
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    40

    Re: Consolidating multiple sheets in master tab and create summary sheet

    Hi Jaslek,
    First of all, my apology for so late responding. As I was away, I was not able to log in and again, sorry for that
    Thanks a lot, it works but there is something if you could fix in!
    When I click "create" without clicking "clear" the master file is updated twice for the same number of tabs again and for this, if you could fix, will be great
    Thanks a lot by the way.
    Farida

  4. #4
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Consolidating multiple sheets in master tab and create summary sheet

    Hi Farida

    Try the attached
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    05-01-2012
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    40

    Re: Consolidating multiple sheets in master tab and create summary sheet

    THANKS A LOT, Jaslake...
    This is greate!

  6. #6
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Consolidating multiple sheets in master tab and create summary sheet

    You're welcome...glad I could help. Thanks for the Rep.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Create a Summary Sheet from Multiple Sheets
    By ronnster in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-05-2014, 07:10 AM
  2. Replies: 1
    Last Post: 01-15-2014, 12:47 PM
  3. Consolidating data from certain sheets in a master summary sheet
    By RoyLittle0 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-09-2013, 04:41 AM
  4. Create a summary from multiple sheets on a master/summary sheet
    By detribus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-07-2012, 08:04 PM
  5. Create Multiple Sheets from master sheet
    By neilshaw in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 05-08-2011, 06:10 AM

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