+ Reply to Thread
Results 1 to 3 of 3

Pull data from multiple sheets based on cell in Main sheet

  1. #1
    Registered User
    Join Date
    04-26-2010
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2007
    Posts
    27

    Pull data from multiple sheets based on cell in Main sheet

    Hello!

    I am trying to create a formula which will allow me to type a word in a cell on the Main sheet, and then pull any row from multiple sheets and display them on the Main sheet. For example, my sheet named Main looks like this:

    A B C D E
    1 Query:
    2 Fruit Store Cost Mode Date



    And there's a sheet for each month with the same format and different data:
    A B C D E
    1 Fruit Store Cost Mode Date
    2 Apple Dominicks 1.99 Bagged 3/16/2014
    3 Apple Piggly Wiggly 2.19 Ala Carte 3/14/2014
    4 Banana Jewel 0.49 Bagged 3/1/2014
    5 Banana Dominicks 0.57 Ala Carte 3/16/2014
    6 Banana Costco 0.69 Ala Carte 3/16/2014
    7 Cantaloupe Jewel 2.99 Ala Carte 3/14/2014
    8 Cantaloupe Dominicks 1.99 Ala Carte 3/1/2014
    9 Eggplant Jewel 0.99 Ala Carte 3/30/2014
    10 Eggplant Dominicks 1.19 Ala Carte 3/30/2014
    11 Eggplant Costco 1.29 Ala Carte 3/21/2014
    12 Eggplant Safeway 0.79 Ala Carte 3/16/2014
    13 Pears Jewel 1.19 Ala Carte 3/14/2014
    14 Pears Dominicks 1.59 Bagged 3/1/2014
    15 Pears Piggly Wiggly 0.99 Ala Carte 3/30/2014
    16 Rhubarb Jewel 0.99 Ala Carte 3/14/2014
    17 Rhubarb Piggly Wiggly 0.59 Ala Carte 3/14/2014
    18 Rhubarb Costco 0.89 Ala Carte 3/14/2014
    19 Tomatoes Jewel 1.99 Ala Carte 3/1/2014
    20 Tomatoes Safeway 1.69 Bagged 3/30/2014
    21 Tomatoes Dominicks 1.89 Carton 3/27/2014


    ... and so on. On my main sheet in Cell B1, I want to type a fruit name, such as Banana, and have every row in every sheet with Banana in column A,pulled and displayed on the Main sheet. Firstly, is this even possible with a formula? and second, any guidance would be most appreciated.
    Last edited by cpyter; 04-29-2014 at 01:17 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Office 365 (work) and Excel 2013 (home)
    Posts
    1,167

    Re: Pull data from multiple sheets based on cell in Main sheet

    I think this needs VBA/Macro. A formula won't do what you are asking.

  3. #3
    Registered User
    Join Date
    04-26-2010
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2007
    Posts
    27

    Re: Pull data from multiple sheets based on cell in Main sheet

    OK, I kinda thought so. I will mark as SOLVED and repost over there, unless I can move it?

+ 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. Copy data from multiple sheets to one main based on cell value
    By jdjenterprises in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-28-2013, 10:13 PM
  2. Macro code to pull the data from different sheets to main sheet
    By Shanthuday in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-14-2012, 09:54 AM
  3. Macro code to pull data from different sheets based on the header of the main sheet
    By Shanthuday in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-21-2012, 05:00 AM
  4. Replies: 0
    Last Post: 01-23-2012, 02:49 PM
  5. Replies: 1
    Last Post: 06-21-2011, 11:29 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