Weekly Task tracker

[Icecoldstar]

I need to be able to create a weekly Tracker that pulls tasks with start and end dates for a schedule in excel. I have tried so many different ways and it seems to be very manual. I would liek to be able to populate the schedule with the project tasks and dates and then have them populate the weekly tracker.

Can anyone help me please??

 

[Skybluekid]

Can you post some data and expect results.

 

[Icecoldstar]

Can you post some data and expect results.

sorry, does this help?

Task name	Start Date
Wireframe Built	28/11/2023
Wireframe Approval	28/11/2023
Pagination Sign Off	28/11/2023
Creative Brief	16/05/2023
Visual and Campaign Message Sign Off	01/08/2023
Pagination Handover	14/07/2023
Product Group Build	17/07/2023
Price Load	17/07/2023
In-Design Pagination	31/07/2023
Supplier Draft Artwork	31/07/2023
DOF Walkthrough 1	15/08/2023
Merch Proof	22/08/2023
Supplier Final Artwork	15/08/2023
Merch Proof Amends	01/09/2023
Final Pricing Lockdown	19/09/2023
Pricing Proof	11/08/2023
DOF Walkthrough 2	03/10/2023
Final Proof	29/09/2023
Final Proof Amends	03/10/2023
CSO Proof	10/10/2023
CSO Proof Amends	11/10/2023
Final Artwork (Sent to Printers)	10/10/2023

 

[Skybluekid]

May I ask where the end dates are? How would you like the tracker to look like?

 

[Icecoldstar]

Task name	Start date	End Date
Wireframe Built	28/11/2023	28/11/2023
Wireframe Approval	28/11/2023	28/11/2023
Pagination Sign Off	28/11/2023	28/11/2023
Creative Brief	16/05/2023	16/05/2023
Visual and Campaign Message Sign Off	01/08/2023	01/08/2023
Pagination Handover	14/07/2023	14/07/2023
Product Group Build	17/07/2023	28/07/2023
Price Load	17/07/2023	17/07/2023
In-Design Pagination	31/07/2023	22/08/2023
Supplier Draft Artwork	31/07/2023	31/07/2023
DOF Walkthrough 1	15/08/2023	15/08/2023
Merch Proof	22/08/2023	31/08/2023
Supplier Final Artwork	15/08/2023	15/08/2023
Merch Proof Amends	01/09/2023	14/09/2023
Final Pricing Lockdown	19/09/2023	19/09/2023
Pricing Proof	11/08/2023	26/09/2023
DOF Walkthrough 2	03/10/2023	04/10/2023
Final Proof	29/09/2023	03/10/2023
Final Proof Amends	03/10/2023	10/10/2023
CSO Proof	10/10/2023	11/10/2023
CSO Proof Amends	11/10/2023	12/10/2023
Final Artwork (Sent to Printers)	10/10/2023	11/10/2023

 

[Icecoldstar]

May I ask where the end dates are? How would you like the tracker to look like?

please see above, I would like them on two separate tabs, one for Schedules data, and one for the weekly tracker. the Weekly Tracker would show the current week with a list of tasks for each day. similar to below.