Excel Macro: Duplicate Row and Zero Numeric Cells

This macro duplicates the row above a button, zeroes out numeric cells in the new row, and updates sum formulas.

How to Use

1. Open the Excel workbook.
2. Press Alt + F11 to open the VBA editor.
3. Import the YourMacro.bas file into a module.
4. Run the macro by clicking the button or pressing F5.

Notes

• Ensure macros are enabled in Excel.
• The button must be placed in the row where you want to insert a new row.