Hi

I have two sheets in my workbook that I need to search down through an
pull data from to generate a third sheet, depending on whether the las
cell in each row has a Yes or No.

I had set this up manually with 'if' statements, worked fine when I ha
to only search 1 sheet, but now there's 2!

Any ideas

--
Darren
-----------------------------------------------------------------------
DarrenG's Profile: http://www.excelforum.com/member.php...fo&userid=3652
View this thread: http://www.excelforum.com/showthread.php?threadid=56282