View Single Post
  #1   Report Post  
Helen McClaine
 
Posts: n/a
Default Copy rows of data to another worksheet where ReturnDate is blank

I'm sure this is do-able within Excel but what formula I should use to
accomplish it escapes me.

Basically, I'm working with a spreadsheet which lists books checked out from
our Resource Center. When the books are returned, the Return Date is entered
in column D.

I want to run a report showing everyone who has outstanding books without
having to go through the spreadsheet, row-by-row, to copy the data to the
worksheet "Outstanding."

Thanks for your help!