How do I write a macro that will ask the user to enter a search value in an InputBox in Sheet 1. It would then look for this string value in columns A:L in Sheet 1. If the string is found, it will copy that entire row into Sheet 2?
I would like the user to be able to type in partial text from...