+ Reply to Thread
Results 1 to 2 of 2

How to combine worksheets into one main sheet using formula

  1. #1
    Registered User
    Join Date
    Carmel, Indiana USA
    MS-Off Ver
    Office 365

    Question How to combine worksheets into one main sheet using formula


    I'm looking to combine multiple worksheets into one master worksheet without having to manually copy and paste or run commands each time. Ideally, i could update, add a row or column for any single workbook and it would then update the master worksheet. All of the header rows would be the same (except when adding a header row to an individual sheet).

    The goal is to export the master sheet as a a CSV with all values from the other sheets and not have to be concerned with values not copying or rows missing. We're looking at approx 500 rows of data and possibly up to 10 sheets.

    Any advice on the best way to accomplish this would be appreciated.


  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016

    Re: How to combine worksheets into one main sheet using formula

    One solution you may wish to explore is utilizing an INDEX(..SMALL(IF formula.

    This formula is good at consolidating information that meets a given criteria.

    Another popular formula is INDEX(..MATCH(COUNTIF))/INDEX(..MATCH(COUNTIF)) which consolidates lists from multiple sources into a single column.

    I'd recommend attaching a mockup of the type of information you're using, with a desired output. We can help connect the dots.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

+ 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] Formula to place data from mulitple worksheets into 1 main sheet
    By lindafinlay in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-19-2013, 03:07 AM
  2. [SOLVED] Splitting Worksheets from Main sheet into several sheets
    By surk. in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 08-06-2012, 04:57 PM
  3. [SOLVED] VBA to create multiple worksheets, rename, and insert information all off main sheet ...
    By headstrong2740 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-03-2012, 10:24 AM
  4. Replies: 3
    Last Post: 09-30-2009, 10:50 AM
  5. How do I combine data from several sheets into one main sheet?
    By Caren F in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-19-2006, 01:45 PM


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