copy data with criteria
 

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=)

--
Regards,
Linda

copy data with criteria
 

Take a look a VLOOKUP function in Help menu


"linda" wrote:

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=)

--
Regards,
Linda

copy data with criteria
 

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.

--
Regards,
Linda


"Teethless mama" wrote:

Take a look a VLOOKUP function in Help menu


"linda" wrote:

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=)

--
Regards,
Linda

copy data with criteria
 

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, DataFilterAdvanced FilterCopy
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
--
Regards
Roger Govier



"linda" wrote in message
...
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=)

--
Regards,
Linda

copy data with criteria
 

thanks Roger!its work=)

--
Regards,
Linda


"Roger Govier" wrote:

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, DataFilterAdvanced FilterCopy
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
--
Regards
Roger Govier



"linda" wrote in message
...
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=)

--
Regards,
Linda