Summary Sheet Task tracker

MarkRush

New Member
Joined
Mar 6, 2018
Messages
28
Hello All and thanks in advance for any help. My organization decided to pull the plug on an project tracker database and put my team in a bind and we need to go back to excel real quick . Each team member has a master workbook that could contain anywhere from 5-25 tabs ( for for each open project). I need a summary sheet that will list all uncompleted tasks for the past 7 and next 7 days.
Project name is in merged cell A3
Due Date is in Column 2
Completed indicator is in Column C and is a drop down list with Y/N

On the summary sheet I would like it to show Customer Name, Due Date, How many days till completion or how many days overdue and all of the data from columns D thru I , Ideally overdue tasks would use a red font

I would like the summary data to refresh every time the workbook is opened or end user moves from project tab to Summary tab

We are using the latest version of O365, but some users are using 64bit some are using 32 bit , everyone is on Windows 10
 

Attachments

  • project sheet.JPG
    project sheet.JPG
    41.4 KB · Views: 43
  • summary sheet.JPG
    summary sheet.JPG
    51.7 KB · Views: 51
Hi,
glad update to your code is going in right direction - unbale to get your link to download anything

Dave
 
Upvote 0

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Forum statistics

Threads
1,223,895
Messages
6,175,257
Members
452,625
Latest member
saadat28

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