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

FM1

Board Regular
Joined
Jan 1, 2008
Messages
62
Office Version
  1. 365
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!
 
Hi FM1. Change this line:
Code:
If ws.Name <> "Late Tasks" Then
to this line:
Code:
If ws.Name Like "*" & "Schedule" & "*" Then
 
  • Like
Reactions: FM1
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top