Template Issues

How to Repeat a Budget Section for Multiple Days in Excel

WPS Content Manager Oct 9, 2026 868 views

Question details

The user needs to dynamically duplicate a fully formatted daily budget section across multiple days based on a start date and duration.

How to Repeat a Budget Section for Multiple Days in Excel

Product: Excel
Device & OS: not provided
Scenario: Creating a multi-day budget template where a daily section containing specific layouts, formulas, and merged cells needs to be repeated.
Observed behavior: Standard Excel formulas can generate dates but cannot duplicate complex section layouts, merged cells, and formats automatically.

Before you start

Before proceeding, ensure your workbook is saved as a Macro-Enabled Workbook (.xlsm), as automating the duplication of formatted sections requires the use of VBA macros.

Solution 1Recommended

Use a VBA Macro to Duplicate the Budget Section

Since standard formulas cannot copy cell formats and merged structures, using a VBA macro is the most reliable way to replicate an entire layout automatically.

A VBA script can select your master day layout, copy it, and loop through a specified number of days to paste the layout sequentially. It can also update the date values dynamically within each newly created section.

Open the VBA Editor

Press ALT + F11 on your keyboard to open the Visual Basic for Applications editor. Go to Insert > Module to create a new blank script.

Write the Copy and Paste Loop

Write a VBA subroutine that defines the source range (e.g., your Day 1 section from A1 to G15). Use a 'For' loop based on the number of days you need, using the Range.Copy and Range.PasteSpecial methods to replicate the section down the sheet.

Update the Date Value

Within your loop, add a line of code to locate the specific cell in the newly pasted section that holds the date, and set its value to the previous section's date plus one.

Run the Macro

Close the VBA editor and return to your worksheet. Press ALT + F8, select your new macro, and click Run to generate the repeated sections.

Use a VBA Macro to Duplicate the Budget Section

Enable Macros: Make sure you have enabled macros in your Excel Trust Center settings, otherwise the VBA script will be blocked from running.

Solution 2

Manually Copy and Paste with Relative References

If you only need to create a template for a few days (e.g., a one-week budget), manual copying with relative formula references is much simpler than writing code.

Manage Budget Templates Seamlessly

Create and Automate Multi-Day Budget Templates with WPS Office

WPS Spreadsheet provides robust support for complex formatting, ready-made templates, and VBA macros, allowing you to easily duplicate daily budget sections and manage finances effectively.

1. Download WPS Office: Install WPS Office for free and launch the WPS Spreadsheet application.
2. Set Up Your Master Layout: Create your initial day's budget layout, applying all desired formatting, merged cells, and calculation formulas.
3. Automate with the Developer Tab: Navigate to the Developer tab to record a macro or write a VBA script that duplicates the section for your required number of days.
4. Save Your Template: Save your completed budget tracker in the standard .xlsm format to maintain compatibility and preserve your automation.

Fully compatible with Microsoft Excel formats, including macro-enabled workbooks (.xlsm).Supports VBA macros to automate repetitive template duplication and formatting.Offers hundreds of free built-in budget and finance templates.Lightweight, free to use, and features a familiar tabbed interface for seamless migration.

microsoft office alternative - wps office

Frequently Asked Questions

Why can't I use standard formulas to duplicate a budget section?

Standard Excel formulas are designed to output data or values into a single cell or array. They cannot alter cell formatting, recreate merged cells, or duplicate a structural layout across a worksheet.

Can I use Office Scripts instead of VBA macros to repeat sections?

Yes, if you are using Excel for the Web or certain Microsoft 365 subscriptions, you can use Office Scripts (based on TypeScript) to automate the copying of a range, including its formatting and structural layout.

How do I ensure formulas update correctly when copying a section?

By default, Excel uses relative cell references. When you copy and paste a block of cells, references to cells within that block will adjust automatically. If a formula needs to lock onto a fixed global cell (like a tax rate), use absolute references by adding dollar signs (e.g., $A$1).

Document & File Issues