+ Reply to Thread
Results 1 to 2 of 2

collating multiple tabs within same workbook to create a master/summary tab

  1. #1
    Registered User
    Join Date
    05-12-2016
    Location
    houston, tx
    MS-Off Ver
    2010
    Posts
    3

    Lightbulb collating multiple tabs within same workbook to create a master/summary tab


    I have a workbook with 4 tabs - 1 tab for each region. In each tab I have a table with hundreds of rows of data which increases each month. Each table has the same columns, same structure, but I keep them separate for ease of reporting, etc. However, I need to have a fifth tab to have a summary of all 4 tabs. I don't want to continue to copy and paste each month because it is a big hassle. Is there any way to create this summary tab so that it reads the other tables automatically and transfers over all the data each month? Please help. Thank you in advance.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: collating multiple tabs within same workbook to create a master/summary tab

    It can be done with a few formulae. You can either enter the data into 4 separate sheets (as you are now doing) and produce a master sheet from them, or do it the other way round, i.e. enter all your data into one master sheet and have it produce the 4 subsidiary sheets automatically. It would help, though, if you attached a sample Excel workbook.

    To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

    Pete

+ 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] Combine multiple workbooks with multiple tabs onto a master workbook
    By loumarday in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-31-2016, 12:33 PM
  2. Linking One Workbook with Multiple Tabs to Master Workbook Formula
    By Scholzie220 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-27-2015, 09:13 AM
  3. [SOLVED] Extract Data from multiple tabs in one workbook to a summary tab
    By iceplant in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-24-2014, 12:36 PM
  4. Extract Data from multiple tabs in one workbook to a summary tab
    By iceplant in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-23-2014, 02:30 AM
  5. [SOLVED] Consolidating multiple sheets in master tab and create summary sheet
    By Farida in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-14-2014, 02:41 PM
  6. Replies: 2
    Last Post: 08-07-2014, 07:05 AM
  7. 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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1