I have a sheet with several thousand rows that looks something like this:

name address city search-term

I want to be able to "search" the search-term column for a key word and then move entire row to a new sheet

There are several examples here I have tried none seem to do above!

Thanks for any guidance.

Dave

EggHeadCafe - Software Developer Portal of Choice
Using COM-Callable Wrappers to Extend Visual Basic 6.0
http://www.eggheadcafe.com/tutorials...le-wrappe.aspx