Hello there, I have a question for mike7952.

I have a question about the Search Data.xlsm file that he posted in post 12 found here:
http://www.excelforum.com/excel-prog...rd-phrase.html
which is outstanding by the way.

My question is, how do I expand the search to include more columns in the Data worksheet, and then have that data show up in the search results in the Search worksheet? I'm not sure at this point how many columns I'd like to search in the Data worksheet (we'll say A through H at this point), but in the future, if I want to search more columns, how would I expand the search to include more / less columns?

Thank you!