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
|