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

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

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

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