In order to optimally load resources to tasks, Project manager need to search for small duration and large duration tasks in entire project. This can be achieved by applying filtering.
This can be done with VBA Script as follow. here Project manager want to search a task of 480 minutes (Hours per day settings at project level configuration settings) i.e. tasks of one man day duration.
VBA Script to Search project tasks of one man day
Output:
Searching project schedule for tasks duration
Need more info?
Need Help! We look forward to assist you master day to day tasks with MS Project.