I need help with what i would assume is a simple macro. I want to have a sheet called Search and in cell A1 there would be a a string and then in another sheet called data I want search and and any rows containing that value or a part of that value would be copied to the Search sheet.
Thanks,
Montrof