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!
|