Results 1 to 2 of 2

Create a summary sheet for multiple worksheets based on multiple criteria with formulas

Threaded View

  1. #1
    Registered User
    Join Date
    06-03-2015
    Location
    Lancaster, PA
    MS-Off Ver
    2013
    Posts
    1

    Create a summary sheet for multiple worksheets based on multiple criteria with formulas

    Hopefully this is the right forum, this is my first post. I have a workbook with 8 worksheets in it. I am looking to have a 9th sheet (the summary sheet) that will pull all the data from each of the sheets based on the value of 2 columns. For example, there is column A to G, with B having a date and G having a status (either "Open" or Closed"). On my summary sheet, I want to be able to input a date a status and then show the entire rows data for everything that matches across all the sheets. The one caveat is that I want to do it with formulas if possible. I have searched the web and found some different options using arrays and ranges the MATCH, INDIRECT, INDEX and COUNTIF functions, but nothing that really covers pulling the whole rows of data across multiple sheets. Also, this needs to be dynamic to so if more rows are added to the individual sheets, the summary sheet will pick those up as well and update. Is this possible without VBA? The columns on each sheet are identical and all formatted the same. Any help would be appreciated. Thank you!

    I have attached a sample of the basic setup of the workbook
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Generating a data summary sheet based on multiple criteria
    By Anuru in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 07-18-2014, 08:03 PM
  2. MACRO to Pull Data from multiple worksheets onto a summary sheet based on an ID
    By eswonson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-04-2013, 03:31 PM
  3. Copying multiple cells from multiple worksheets to one summary sheet
    By Dragothemensch in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-18-2013, 08:39 PM
  4. [SOLVED] Summary Sheet from Multiple Worksheets or Creating a Formula based on text
    By dsunter in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-20-2012, 11:12 AM
  5. Summary sheet to create multiple worksheets
    By originata in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-07-2012, 05:42 PM

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