+ Reply to Thread
Results 1 to 1 of 1

To modify macro based on criteria in input sheet to lookup on criteria then extract data

  1. #1
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    EXCEL 2016
    Posts
    1,052

    To modify macro based on criteria in input sheet to lookup on criteria then extract data

    Hi All

    I have several several database in a workbook which refers to specific suppliers .

    The imput sheet is named sample column A and B are blank when clicked on button , macro triggers lookup sample Data base and extracts from database column C header reference, if no data is found column A and B remains blank.

    What I am looking actually is modify the macro or better solution I have added a search criteria column L in imput sample sheet

    That is lookup in L2 criteria and search on the sheet tabs if it tallies then lookup in that sheet tab to perfom lookup and extract data column C and D

    Take note thre will be 20 supplier sheets tabs or more

    Thanks if anyone can help
    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. Replies: 3
    Last Post: 12-18-2014, 10:27 AM
  2. Macro to extract data based on defined criteria
    By The_Snook in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-23-2014, 09:10 AM
  3. [SOLVED] Need a lookup to extract data table based on four criteria & override user input
    By Marvelous in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-01-2013, 12:54 PM
  4. Extract Data from one sheet to another based on criteria
    By alghareeb in forum Excel General
    Replies: 1
    Last Post: 05-08-2013, 09:16 AM
  5. Replies: 4
    Last Post: 01-08-2013, 12:37 PM
  6. Replies: 11
    Last Post: 07-11-2012, 06:08 PM
  7. Replies: 2
    Last Post: 03-23-2011, 06:19 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