I have a project schedule setup in Excel to help track and monitor individual tasks. I am in need of a macro which will extract all 'late' tasks which are 'incomplete' into a 'Late Tasks' worksheet.
Workbook setup
6 Worksheets: Plan 1, Plan 2, Plan 3, Plan 4 and Plan 5 (same setup) and Late Tasks
Worksheet setup
Column A = Irrelevant (colour only cell)
Column B = "Plan"
Column C = "Workstream"
Column D = "Task ID"
Column E = "Deliverable"
Columns F:I (irrelevant for macro... I think)
Column J = "Baseline_Finish"
Column K = "Finish_Date"
Column L = "Status"
Ideally, I woul need a macro which extracts all 'late tasks', i.e. Finish_Date greater than Baseline_Date which are incomplete, i.e. Status = "Incomplete", which are imported into the 'Late Tasks' worksheet.
I have setup a template but I cant seem to find the attachment option any more. Im assuming the functionality has been taken out. If anyone is interested to see the file, i can upload it to a fileshare website if that makes things easier.
Thanks!
Workbook setup
6 Worksheets: Plan 1, Plan 2, Plan 3, Plan 4 and Plan 5 (same setup) and Late Tasks
Worksheet setup
Column A = Irrelevant (colour only cell)
Column B = "Plan"
Column C = "Workstream"
Column D = "Task ID"
Column E = "Deliverable"
Columns F:I (irrelevant for macro... I think)
Column J = "Baseline_Finish"
Column K = "Finish_Date"
Column L = "Status"
Ideally, I woul need a macro which extracts all 'late tasks', i.e. Finish_Date greater than Baseline_Date which are incomplete, i.e. Status = "Incomplete", which are imported into the 'Late Tasks' worksheet.
I have setup a template but I cant seem to find the attachment option any more. Im assuming the functionality has been taken out. If anyone is interested to see the file, i can upload it to a fileshare website if that makes things easier.
Thanks!