Check out the thread "Extract Whole Row If Q" in the
microsoft.public.excel.programming group, you will need some more
macro expertise to debug and implement this code for your project.
I am a MACRO making fool. I am getting it to everything I need it took a
while to get the exact coding and order down but I am getting there... I just
hope there is not a limit of lines of code I can put into a macro. LOL!!!! My
first Macro has about 308 lines of code...LOL!!!!!!