Code
Convert a spreadsheet macro
VBA rewritten as a script, with the outputs proved identical.
Fill it in
With its macro.
Same inputs, same outputs, diffed.
A script with arguments, not a notebook.
Your prompt
Convert this macro to a script. Read what it actually does before rewriting, including the parts that look accidental. Finance macros accumulate deliberate oddities: a rounding order that matters, a hard-coded date that marks a policy change, a column skipped for a reason nobody wrote down. Prove equivalence. Run both against the same workbook and diff the outputs cell by cell, and report anything that differs rather than deciding it was a bug. Make it a script with arguments, not a notebook. It is replacing something that runs on a schedule. List every behaviour you could not explain. That list is what a human has to look at before this replaces anything.
Use Convert a spreadsheet macroOpens with everything above already filled in.
Why this works
Finance macros accumulate deliberate oddities: a rounding order that matters, a hard-coded date marking a policy change. This proves equivalence cell by cell and reports differences rather than deciding they were bugs, and lists what it could not explain.