All Recipes

2 macro recipes for tax workpapers.

• 2026-08-31 · 3 min read Workpaper Management

  Bulk Date Updater: Change the Period-End Date Across Every Sheet at Once

  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.

• 2026-08-03 · 10 min read Workpaper Management

  Auto Table of Contents: Never Hunt for a Tab Again

  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.