+ Reply to Thread
Results 1 to 4 of 4

Lookup Macro for multiple tabs

  1. #1
    Registered User
    Join Date
    11-05-2014
    Location
    SF
    MS-Off Ver
    Excel 2010
    Posts
    39

    Lookup Macro for multiple tabs

    Hi, I would love if someone could help me with a macro/program that pulls certain items from different tabs in a specific order/column. Here's what I mean:

    1. All Features are pulled from the Feature tab into the master tab's column A.
    2. Starting on the row below the last feature, Master tab's column B displays the next tab's Column C listed row-by-row.
    3. Then the last 3 tabs stay in the same Master Column (B), but start once the previous tab has been populated.

    I've created a visual example in the attached excel. It is a basic version, as mine will have about 15,000 rows, so I need it to translate.

    Thanks in advance for your help!

    -Excelnoob
    Attached Files Attached Files
    Last edited by excelnoob927; 12-23-2014 at 07:00 PM. Reason: solved

  2. #2
    Forum Contributor
    Join Date
    09-30-2013
    Location
    Toronto, ON
    MS-Off Ver
    Excel 2007
    Posts
    229

    Re: Lookup Macro for multiple tabs

    I think that there's something missing. You talk about a Features tab but the only tabs are Master and DPOB.
    None of the tabs have anything in column C.
    Can you provide a better example of the data and the expected output?
    If this helped, please click (*) Add Reputation

  3. #3
    Registered User
    Join Date
    11-05-2014
    Location
    SF
    MS-Off Ver
    Excel 2010
    Posts
    39

    Re: Lookup Macro for multiple tabs

    Sorry, you're right! I updated the Excel spreadsheet in the Post. It should be correct now. Much appreciated!

  4. #4
    Forum Contributor
    Join Date
    09-30-2013
    Location
    Toronto, ON
    MS-Off Ver
    Excel 2007
    Posts
    229

    Re: Lookup Macro for multiple tabs

    ExcelForumMacro v2.xlsm
    This should do it. As long as columns and sheet names don't change.

+ 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. vba lookup logic for multiple tabs
    By bordensize in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-04-2013, 06:02 PM
  2. [SOLVED] 4 Way Lookup/Match - Across Multiple Tabs - Return One Value
    By skyraptor in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-04-2013, 12:38 AM
  3. Replies: 6
    Last Post: 02-01-2012, 05:29 PM
  4. lookup with multiple criteria on multiple tabs
    By tf2722 in forum Excel General
    Replies: 5
    Last Post: 11-01-2011, 05:53 PM
  5. Value lookup from multiple tabs
    By rmantoo in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 03-16-2010, 08:10 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