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: 17
  • summary sheet.JPG
    summary sheet.JPG
    51.7 KB · Views: 18

dmt32

Well-known Member
Joined
Jul 3, 2012
Messages
7,049
Office Version
  1. 2019
Platform
  1. Windows
Hi,
glad update to your code is going in right direction - unbale to get your link to download anything

Dave
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,115
Messages
5,768,196
Members
425,459
Latest member
Danniey

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
Top