I'm sure this would be quite easy to do. However, without a specific
example it's difficult to know exactly what your requirements are. Can you
post an example workbook?

"DarrenG" <DarrenG.2b71v3_1153314907.429@excelforum-nospam.com> wrote in
message news:DarrenG.2b71v3_1153314907.429@excelforum-nospam.com...
>
> Hi
>
> I have two sheets in my workbook that I need to search down through and
> pull data from to generate a third sheet, depending on whether the last
> cell in each row has a Yes or No.
>
> I had set this up manually with 'if' statements, worked fine when I had
> to only search 1 sheet, but now there's 2!
>
> Any ideas?
>
>
> --
> DarrenG
> ------------------------------------------------------------------------
> DarrenG's Profile:
> http://www.excelforum.com/member.php...o&userid=36529
> View this thread: http://www.excelforum.com/showthread...hreadid=562825
>