Macros for formatting, navigating, and managing tax workpapers. Auto table of contents and more.
One macro that checks A3 on every sheet for a date and replaces it with your new period-end. No more clicking through 40 tabs to update the same cell.
Scans every sheet in a workbook, builds a hyperlinked table of contents on a new index sheet, and auto-updates when tabs are added, renamed, or deleted. The 30-tab workbook just became navigable.