Macro: extract data from multiple shhets and import into destination sheet based on date qualifier

[FM1]

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!

 

[mumps]

Hi FM1. Change this line:

If ws.Name <> "Late Tasks" Then

to this line:

If ws.Name Like "*" & "Schedule" & "*" Then

 

[FM1]

Worked perfectly.

Thanks so much again Mumps. You're a legend!

 

[mumps]

My pleasure!