I have a spreadsheet with multiple sheets. The sheet called “Active Projects” has a table with all active projects in rows and the workload of each project in column H.
Rows 1 and 2 are headlines and row 2 contains an Autofilter.
What I would like to do is that when:
... the autofilter in cell H2 is updated to shows the highest value first, so I have the 10 projects with highest workloads placed first in the table.
Can anybody help with the VBA code for this sheet?
Rows 1 and 2 are headlines and row 2 contains an Autofilter.
What I would like to do is that when:
- You change the workload in column H (percentage) for an existing project...
- When you add a new project/row and add the workload in column H...
... the autofilter in cell H2 is updated to shows the highest value first, so I have the 10 projects with highest workloads placed first in the table.
Can anybody help with the VBA code for this sheet?
Last edited: