+ Reply to Thread
Results 1 to 4 of 4

extract data based on four criteria in excel sheet or VBA code to extract

  1. #1
    Registered User
    Join Date
    02-14-2014
    Location
    saudi arabia
    MS-Off Ver
    Excel 2010
    Posts
    21

    Exclamation extract data based on four criteria in excel sheet or VBA code to extract

    Hi,
    Please Help me ,I need to extract data based on input in two cell and extract two data with four criteria please loo at the example,help me!!!

    please find below table or attachment

    Week No. 1 2 3 4 5 6 7 8 9 10 11 12 13 14
    P-001 A C/O 3
    B C/O 14

    Need to retrieve data column A and column C data based on
    1)week no
    2)date in that particular week
    3)column C data to be selected based on green indiaction


    for example:

    WEEK NO IF IT IS WEEK 14
    DATE IF IT IS DATE 2

    RETIEVED DATA SHOULD BE AS FOLLOWS
    PUMP TAGS A OR B
    P-001 A ( SINCE Cell 2R indicates Green color)


    -Navanee
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    02-14-2014
    Location
    saudi arabia
    MS-Off Ver
    Excel 2010
    Posts
    21

    Re: extract data based on four criteria in excel sheet or VBA code to extract

    Anybody please help me!!!!

  3. #3
    Registered User
    Join Date
    10-21-2014
    Location
    VIET NAM
    MS-Off Ver
    2007
    Posts
    9

    Re: extract data based on four criteria in excel sheet or VBA code to extract

    I do not understand

  4. #4
    Registered User
    Join Date
    02-14-2014
    Location
    saudi arabia
    MS-Off Ver
    Excel 2010
    Posts
    21

    Re: extract data based on four criteria in excel sheet or VBA code to extract

    Thanks for showing interest , I hope my problem will be challenging on , Did you check my attached file, I just want to extract the pump name based on input data like week number and date and finally should take out pump name based on cell color also that is green color ( since this one is pump change over schedule for whole year)

    Thank you !! please help me Mr.Nguyen PHI HA

    Regards
    navanee

+ 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. 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
  2. [SOLVED] Extract data based on 1 criteria
    By TexasRhode in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-06-2012, 06:08 PM
  3. extract rows from sheet based on multiple criteria
    By frederikk in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-05-2012, 04:12 AM
  4. Replies: 11
    Last Post: 07-11-2012, 06:08 PM
  5. 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