Hi, I am fairly new to excel programming. I have a problem where i am currently stuck.

Say I have 5000 X 20 rows & columns of data. I need to filter them based on 3 or 4 search words and display the only resultant rows in another sheet.

Cell need not match the keyword exactly. For example the cell contains "blue greenyellow" and my keyword is "green", macro should still pick that entire row. Its like clicking ctrl F.

Ideal way would be

1. when I run the macro, a pop up opens and asks me "how many keywords?"
2. Once, I type say 3, 3 popups will promt me to enter 3 keywords.
3. when done, a new excel sheet open with all the rows (and all columns in those rows) containing those 3 keywords.

Also, it would be great, if excel can look entire workbook so that we do not have to specify the range in cells to look for in the macro.

Please help! Thank you.