Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find and copy it..
hi all...
hoping u can help me for saving my time. i have a master data in sheet 1 with more than 1000 rows. and now in sheet 2 i want to copy data from master in sheet 1 which some condition. i.e in sheet 1 Col A(ID), col B(name), Col C(city), Col D(address), Col E(birthday), Col F(Status) etc (until col J(Note)) now in sheet2 i want to copy some data which conditions: if ID="23", name="bob" and city="NewYork" then it will copy all row from col B(name) til Col J(Notes). thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
find and copy it..
Use AdvancedFilter;
http://www.ozgrid.com/Excel/advanced-filter.htm -- Regards Dave Hawley www.ozgrid.com "reza" wrote in message ... hi all... hoping u can help me for saving my time. i have a master data in sheet 1 with more than 1000 rows. and now in sheet 2 i want to copy data from master in sheet 1 which some condition. i.e in sheet 1 Col A(ID), col B(name), Col C(city), Col D(address), Col E(birthday), Col F(Status) etc (until col J(Note)) now in sheet2 i want to copy some data which conditions: if ID="23", name="bob" and city="NewYork" then it will copy all row from col B(name) til Col J(Notes). thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy contents of Find (Find and Replace) | Excel Discussion (Misc queries) | |||
Find and Copy | Excel Discussion (Misc queries) | |||
Find then copy | Excel Worksheet Functions | |||
find and copy | Excel Worksheet Functions | |||
Find and copy?? | Excel Worksheet Functions |