Items left open

[copeco]

Good morning..
File has rows A?:K? (open ended as rows are added frequently). row B?(date submitted) row F?(date rec'd) All this on sheet1.
The "want to do" is: On sheet2 show all rows(A?:K?)that do have row B?(date submitted)filled in, but do not have row F? (date rec'd)filled in. eg(if row B? > "blank" and row F?= "blank&quot ....thank you

 

[xlbo]

Have a look at Advanced Filter - should do what you want Rgds
~Geoff~

 

[copeco]

Geoff,
Thanks for the info. In my situation, I have to forward a listing to another manager showing all the open PO's along with the rest of the corresponding info in the same row. I was trying to create a list on sheet2 that would be automatically updated. I'm not sure how to do that with the info you have given me...thanks

 

[copeco]

Geoff,
I have practiced with the AutoFilter(couldn't figure out the AdvancedFilter). This one will work. The entire file has to be sent, but that's ok. Thanks for your help.