copy data with criteria

[Guest]

Hi!
i am trying to copy data of certains rows from 2 columns that match the
criteria choosen.i have 4 columns, ID, DATE, CUST, MOD.the criteria is for
DATE,but i want to copy column CUST & MOD to another worksheet.can it be done?
i've tried to use advanced filter,but it seems like copy DATE column
only,cannot copy CUST & MOD.
is there any other suggestion?
thanks in advance=)

 

[Guest]

Take a look a VLOOKUP function in Help menu

 

[Guest]

thanks for repply..i've try that but VLOOKUP only return a single
value.moreover,the 2 columns i need is not side by side.

 

[Roger Govier]

Hi Linda

Advanced Filter should work for you.

On the destination sheet, enter in cells A1 and B1 the column headings that
you are interested in from the source sheet.
In A2 and B2 enter the criteria that must be matched to select the rows.

Then, starting from the destination Sheet, Data>Filter>Advanced Filter>Copy
to another location
List range> Select the complete range of data from your source sheet
Criteria range> cells A1:B2 of your destination sheet
Copy to> Select A4:M4 of your destination sheet

I have used M4 in my example. Ensure the column letter chosen is enough to
include all the columns of data you want extracted from the source.

For more help on advanced filter take a look at
http://www.contextures.com/xladvfilter01.html#ExtractWs

 

[Guest]

thanks Roger!its work=)

--
Regards,
Linda

Hi Linda

Advanced Filter should work for you.

On the destination sheet, enter in cells A1 and B1 the column headings that
you are interested in from the source sheet.
In A2 and B2 enter the criteria that must be matched to select the rows.

Then, starting from the destination Sheet, Data>Filter>Advanced Filter>Copy
to another location
List range> Select the complete range of data from your source sheet
Criteria range> cells A1:B2 of your destination sheet
Copy to> Select A4:M4 of your destination sheet

I have used M4 in my example. Ensure the column letter chosen is enough to
include all the columns of data you want extracted from the source.

For more help on advanced filter take a look at
http://www.contextures.com/xladvfilter01.html#ExtractWs