Introduction To The Excel Data Model & Relationships
Have you ever been in a VLOOKUP hell?
Recent posts
Paste Values With Vba With A Keyboard Shortcut Permalink
This will show how to use VBA to paste values in Excel instead of formulas. You can bind this VBA macro to the Ctrl+Shift+V keyboard shortcut to make pasting...
List All Vba Environment Variables
This VBA Environment function grabs information about your operating system and returns the information as a string. The Environ function is useful for custo...
How To Include The Document Version With Export To Excel From Sharepoint
When you have a SharePoint Document Library and use the Export to Excel feature, you may have noticed that document versions will not be exported to the work...
Colour Banding With Conditional Formatting
Use Conditional Formatting from the Format menu to apply a format to the cells. The formula used in the Conditional Formatting rule is based solely on the ro...