+ Reply to Thread
Results 1 to 4 of 4

Filter single criteria across all worksheets and return values to a summary sheet

  1. #1
    Registered User
    Join Date
    04-02-2014
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    79

    Filter single criteria across all worksheets and return values to a summary sheet

    Hi,

    Please help me with a VB code to Filter single criteria selected from a data validation list across all worksheets and return values to a summary sheet.All the sheets have same headers.
    Attached a sample of this.

    Thanks
    Shreeja
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Filter single criteria across all worksheets and return values to a summary sheet

    Maybe:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    04-02-2014
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    79

    Re: Filter single criteria across all worksheets and return values to a summary sheet

    its works well John.. thanks a lot...

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Filter single criteria across all worksheets and return values to a summary sheet

    You're welcome. Glad to help out and thanks for the feedback.

+ 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. Use VBA to scan and copy rows from worksheets with criteria met to a summary sheet
    By nuttyengineer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-31-2011, 05:28 PM
  2. Replies: 6
    Last Post: 05-18-2011, 02:03 PM
  3. Replies: 0
    Last Post: 12-07-2010, 12:41 PM
  4. Return Values Single Criteria
    By Rage in forum Excel General
    Replies: 7
    Last Post: 03-11-2010, 12:33 PM
  5. [SOLVED] How do I reference values from 200 worksheets onto a summary sheet
    By mac849 in forum Excel General
    Replies: 4
    Last Post: 03-17-2005, 06:06 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