Hi All
Can anybody help with this problem, I have a worksheet that lists all
jobs that require a revisit i.e. part required etc after an engineer
visit.

Columns A - H contain all the details, and Columns I - J contain a
Yes/No dropdown, defaulted to No. Column I would wait for a reference
number before job can be done, and Col J is when a job is completed. So
eventually both cells will say 'Yes.

As this list is emailed every week and would eventually build up, the
jobs that are completed can be deleted so can I put in a macro to
delete any row where column's ‘I and ‘J are both ‘Yes after 14 days.

The reason for the 14 days is so that any emailed sheet would contain
the completed jobs at least once.

Hope this is clear enough
Bern


--
bern
------------------------------------------------------------------------
bern's Profile: http://www.excelforum.com/member.php...o&userid=20169
View this thread: http://www.excelforum.com/showthread...hreadid=478877