Validation and execution
The worksheet is loaded with the selected item, location and period and emailed to the
specified user, on successful validation and execution of the macro. These are the validation
rules:
- If the macro parameters are Null, the default value specified in worksheet for item, location and period selections are used.
- If the macro parameters and the worksheet default parameters for item, location and period are Null, the top node selections of item, location and period are used.