| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting row after 14 days if...
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to pull <=14 Days, <=30 Days, 30 Days from a date column | Excel Discussion (Misc queries) | |||
| Employee days worked (-Holidays, -weekends, Snow Days, etc) | Excel Discussion (Misc queries) | |||
| Calc days between two dates and exclude leap year days | Excel Worksheet Functions | |||
| Conditional Formatting Dates calculating 10 days and 30 days from a certain date | Excel Worksheet Functions | |||
| Deleting Hyphens or Dashes from multiple cells without deleting the remaining content | Excel Programming | |||
Threaded Mode
