Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find text and copy and move row containing it
Is it possible to ask excel to look for a specific phrase then copy the rows that contain that phrase and then paste the rows into a new worksheet? So . . . In column A I have: 1 blue sand shoes 2 blue canaries singing 3 blue canaries wearing shoes In this example excel would copy and past rows 1 and 3 into a new worksheet. If that's too complicated could it find the cells containing blue and shoes and copy the contents of those cells into a new column? Thanks for your help Gillian -- gjpcoach ------------------------------------------------------------------------ gjpcoach's Profile: http://www.excelforum.com/member.php...o&userid=31900 View this thread: http://www.excelforum.com/showthread...hreadid=516279 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I copy an entire worksheet to another with text & format? | Excel Discussion (Misc queries) | |||
copy and pasting a find all list into another column | Excel Discussion (Misc queries) | |||
Can i move scanned jpeg text to excel spreadsheets | Excel Worksheet Functions | |||
Find text in another workbook and paste if found match - VBA | Excel Discussion (Misc queries) | |||
Sort or Filter option? | Excel Worksheet Functions |