Excel 2026 Roll-Forward Update
Budget: $10 – $30 USD
I need my existing multi-tab workbook rolled forward from 2025 to 2026.
At the moment every formula, lookup and total references 2025; simply changing the year breaks the downstream links, so I’m looking for someone to update the logic across the entire sheets involved—Master, Weekly and Monthly—so that everything automatically pulls the correct 2026 figures.
Key points to address
• Master tab – the blue-shaded date columns must still mark Saturdays and Sundays, only now based on the 2026 calendar. No change in colour or style, just correct placement for the new year.
• Weekly tab – row 1 begins with 1 January 2026; column A then lists each subsequent Monday of the year. The existing formulas that populate the rest of the row should continue to work untouched once the dates are correct.
• Monthly tab – all month-end totals and summaries must receive their inputs from the refreshed Weekly and Master tabs so that monthly figures reconcile automatically.
Please keep the current layout, conditional formatting rules and named ranges intact; only adjust what is necessary to make the workbook fully functional for 2026. A quick test file showing January working end-to-end will be the first checkpoint, followed by the completed full-year workbook.
At the moment every formula, lookup and total references 2025; simply changing the year breaks the downstream links, so I’m looking for someone to update the logic across the entire sheets involved—Master, Weekly and Monthly—so that everything automatically pulls the correct 2026 figures.
Key points to address
• Master tab – the blue-shaded date columns must still mark Saturdays and Sundays, only now based on the 2026 calendar. No change in colour or style, just correct placement for the new year.
• Weekly tab – row 1 begins with 1 January 2026; column A then lists each subsequent Monday of the year. The existing formulas that populate the rest of the row should continue to work untouched once the dates are correct.
• Monthly tab – all month-end totals and summaries must receive their inputs from the refreshed Weekly and Master tabs so that monthly figures reconcile automatically.
Please keep the current layout, conditional formatting rules and named ranges intact; only adjust what is necessary to make the workbook fully functional for 2026. A quick test file showing January working end-to-end will be the first checkpoint, followed by the completed full-year workbook.
Related categories:
Visual Basic
Data Processing
Data Entry
Excel
Excel VBA
Excel Macros
Data Analysis
Data Management