I keep a examples of useful excel hacks that I have created or discovered. These are all things that I have actually used. They generally require advanced or expert knowledge to create but are easy enough to understand if explained. These are being added to a separate section on my website ExcelMonkey.org.
Today I have included:
- Listing all sheets in a workbook using a small amount of VBA
- Use range names where your list length varies (so called Dynamic Ranges’)
- Summing items that appear of different lines in several worksheet tabs
The full list can be found on my Useful Excel Hacks page