Hi,
I am really stuck. I need help writing a macro to search for a word or number (that the user inputs so preferably as an input box) in 5 columns and if it appears in any of these columns then for that row to be copy and pasted into a new sheet. And then for the search to continue onto the next row so that any rows that have this search term are on the new sheet (there are 5000 rows). Any help will be greatly apprectiated!