+ Reply to Thread
Results 1 to 3 of 3

Search variable number of sheets to find partial match on name

  1. #1
    Registered User
    Join Date
    06-19-2014
    Location
    Charleston, SC
    MS-Off Ver
    2010
    Posts
    2

    Search variable number of sheets to find partial match on name

    Can you please help? I have a monthly report.
    Worksheets for each month, each row is a type of fruit (column A), and the number sold (column B).
    A new worksheet is added each month with the information.
    I also have a Summary worksheet - running total of all months: Type of Fruit (column A), Number sold (column B), and Total of all fruits - number sold.
    I would like a formula for the Summary worksheet - to match that fruit (column A) to any of the other worksheets - matching the fruit (column A), and bring back the number sold (column B). (note some apples are Fuji and some are Honey crisp - those would be totaled together)
    Thank you

    ex:
    Tab = Jan 14
    Fuji apples 3
    Bananas 2
    grapes 9
    TOTAL 14

    Tab = Feb 14
    apricots 7
    honeydew 22
    honey crisp apples 17
    TOTAL 46

    Tab = Mar 14
    Strawberries 58
    TOTAL 58

    Tab = Summary
    apples 127
    bananas 111
    honeydew 220
    apricots 557
    etc
    TOTAL 5440

  2. #2
    Valued Forum Contributor Saarang84's Avatar
    Join Date
    02-19-2009
    Location
    Chennai, India
    MS-Off Ver
    XL 2003 to 2010
    Posts
    812

    Re: Search variable number of sheets to find partial match on name

    Hi,

    Welcome to the Forum.

    Can u post a workbook with sample data removing all sensitive information?
    If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.

    If your requirement has been solved please mark your thread as Solved.
    In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".

    Kindly use [FORMULA] or [CODE] tags when posting your code.

    Regards,
    Sarang

  3. #3
    Registered User
    Join Date
    06-19-2014
    Location
    Charleston, SC
    MS-Off Ver
    2010
    Posts
    2

    Re: Search variable number of sheets to find partial match on name

    thanks for the welcome.
    here is an example workbook
    Attached Files Attached Files

+ 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. Search and copy based on partial text match
    By PIQalap in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-12-2014, 11:36 AM
  2. Replies: 0
    Last Post: 09-21-2013, 09:03 PM
  3. [SOLVED] Vlookup, Match (Search or Find) partial string within string in a Cell
    By dluhut in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-28-2013, 12:40 PM
  4. [SOLVED] Search for a partial string match and cycle through matching results
    By kamelkid2 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-08-2013, 08:27 AM
  5. search for partial match
    By bbmh in forum Excel General
    Replies: 4
    Last Post: 10-05-2006, 09:30 AM

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