Advanced Filter Macro for MS Project
Budget: $250 – $750 USD
I'm looking for an experienced professional to create a user form macro in MS Project Professional. The macro should have the following capabilities:
The key functionality that the macro should have is the ability to filter the project based on selected criteria in the user form, including:
- Project Phase: This is a custom field, or Text1
- (And) Work Phase: This is a custom field, or Text6
- (And) Custom Look-Ahead Formula's for 15, 30, & 60 day look-aheads. See attachment but the end user will select one of the three look-ahead options.
For the Look-Ahead formula, it should be defined as: IIf(([Start]<([Status Date]+15, 30, or 60) And ([% Work Complete]<100))).
It's extremely critical that the candidate has strong proficiency and understanding of MS Project macros, logical formulas, and project scheduling principles.
The key functionality that the macro should have is the ability to filter the project based on selected criteria in the user form, including:
- Project Phase: This is a custom field, or Text1
- (And) Work Phase: This is a custom field, or Text6
- (And) Custom Look-Ahead Formula's for 15, 30, & 60 day look-aheads. See attachment but the end user will select one of the three look-ahead options.
For the Look-Ahead formula, it should be defined as: IIf(([Start]<([Status Date]+15, 30, or 60) And ([% Work Complete]<100))).
It's extremely critical that the candidate has strong proficiency and understanding of MS Project macros, logical formulas, and project scheduling principles.