| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to find a word and copy all rows with this word to diff ws
I'm trying to create a macro to run a search based on info put into an input
box and copy all of the rows from column A to column M containing this info and paste to a specific worksheet. The worksheet that the info will be found in will always be the same format, this info will always in the same columns but different & multple rows. I hope that makes sense, any help would be greatly appreciated. Thanks Chas |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to find a word and copy all rows with this word to diff ws
You can filter and copy the visible cells
http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Chas" wrote in message ... I'm trying to create a macro to run a search based on info put into an input box and copy all of the rows from column A to column M containing this info and paste to a specific worksheet. The worksheet that the info will be found in will always be the same format, this info will always in the same columns but different & multple rows. I hope that makes sense, any help would be greatly appreciated. Thanks Chas |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to find a word and copy all rows with this word to diff
Thanks for your response, however I can't auto filter because the text could
be within a string of text & the string of text won't always be the same. So i need to find this text within a string of text then copy the row containing that info. "Ron de Bruin" wrote: You can filter and copy the visible cells http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Chas" wrote in message ... I'm trying to create a macro to run a search based on info put into an input box and copy all of the rows from column A to column M containing this info and paste to a specific worksheet. The worksheet that the info will be found in will always be the same format, this info will always in the same columns but different & multple rows. I hope that makes sense, any help would be greatly appreciated. Thanks Chas |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to find a word and copy all rows with this word to diff
You can use Auto filter
For example Criteria1:="=*ron*" -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Chas" wrote in message ... Thanks for your response, however I can't auto filter because the text could be within a string of text & the string of text won't always be the same. So i need to find this text within a string of text then copy the row containing that info. "Ron de Bruin" wrote: You can filter and copy the visible cells http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Chas" wrote in message ... I'm trying to create a macro to run a search based on info put into an input box and copy all of the rows from column A to column M containing this info and paste to a specific worksheet. The worksheet that the info will be found in will always be the same format, this info will always in the same columns but different & multple rows. I hope that makes sense, any help would be greatly appreciated. Thanks Chas |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy from Word to Excel, and retain indent, plus word wrap | Excel Discussion (Misc queries) | |||
| macro to intsert a word using the "Find" command to search for a word | Excel Programming | |||
| search for a specific word and copy the word and the preceeding words until a comma | Excel Programming | |||
| how to add word to the front of every word in all rows automatica. | Excel Discussion (Misc queries) | |||
| Find word and copy | Excel Programming | |||
Hybrid Mode
