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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find text and copy and move row containing it
I'd apply Data|Filter|autofilter to that column.
Then for your example: Then use a custom filter contains: blue or contains: shoes Then copy|paste those visible cells where you want them. gjpcoach wrote: 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find text and copy and move row containing it
Oops. Make that AND instead of OR:
I'd apply Data|Filter|autofilter to that column. Then for your example: Then use a custom filter contains: blue AND contains: shoes Then copy|paste those visible cells where you want them. gjpcoach wrote: 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 -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find text and copy and move row containing it
Thanks Dave. I was hoping for something more automated that didn't require me to copy and past by hand. Am I wanting something beyond Excel's capabilities? thanks Gillian -- gjpcoach ------------------------------------------------------------------------ gjpcoach's Profile: http://www.excelforum.com/member.php...o&userid=31900 View this thread: http://www.excelforum.com/showthread...hreadid=516279 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find text and copy and move row containing it
If you tell excel what to do in a macro, it'll do it.
Try recording a macro when you do it once manually and you'll see the code. Then post back with more specific questions. gjpcoach wrote: Thanks Dave. I was hoping for something more automated that didn't require me to copy and past by hand. Am I wanting something beyond Excel's capabilities? thanks Gillian -- gjpcoach ------------------------------------------------------------------------ gjpcoach's Profile: http://www.excelforum.com/member.php...o&userid=31900 View this thread: http://www.excelforum.com/showthread...hreadid=516279 -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find text and copy and move row containing it
Thanks Dave I'll give it a go. Gillian -- gjpcoach ------------------------------------------------------------------------ gjpcoach's Profile: http://www.excelforum.com/member.php...o&userid=31900 View this thread: http://www.excelforum.com/showthread...hreadid=516279 |
Reply |
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 |