Continuous Flow Task Tracker with VBA- Full Overview and Tutorial (Excel)
There is a new Excel version launched!
You can find the tutorial here:
• Build your own Rolling Automated Task Trac...
Let’s create an automated task tracker for a seamless experience. The automations require VBA. If you can't use VBA at work, the non-automated version is a better fit for you to get organized at work. If you have the ability to use VBA as work, this tracker is the way to go to be organized at work.
This is the second and most recent version of this task tracker in Excel:
Note: VBA is not transferrable to Google Sheets. If you want to find an automated Google Sheets version, see my video for the Continuous Flow Task Tracker with Apps Script in Google Sheets.
What we'll learn:
Set up column headers
Add Drop-downs
Create an automatic counter
Add a completed task counter
Add conditional formatting
Add automatic timestamps for status updates
Create pivot tables
Create visualizations of completed tasks
Formulas/ Features Covered:
Data Validation (Drop Down)
Max
Offset
Iferror
ISBLANK
CountIFS
Conditional Formatting
VBA
If statement
Pivot Tables
Stacked Bar Charts