Thanks to everyone who attended today’s session. As we discussed, the macro in the spreadsheet below is designed for use in a 4.x environment.
You can download the 4.x document here: adherence-macro. Here’s where you can download the presentation.
Web Resources:
- Dynamic Named Ranges… regular and advanced
- Best Practices in spreadsheet design from Ozgrid
- Dates and times by cpearson, Microsoft, or Ozgrid
- Start learning about pivot tables
- Use calculated fields in pivot tables
- Pivot charts and more (from Microsoft)





