Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy Row to worksheet based on criteria | Excel Discussion (Misc queries) | |||
Auto copy down depending on criteria | Excel Worksheet Functions | |||
Copy DSUM Criteria Question | Excel Worksheet Functions | |||
copy rows meeting criteria to another worksheet | Excel Worksheet Functions | |||
under certain criteria copy data. | Excel Worksheet Functions |