G
Guest
Have a spreadsheet with budget numbers. Need macro to insert row ABOVE each
existing row, insert text "Actual" in "B,row#" at EVERY line (so I can key in
actuals), then insert a row BELOW the existing data, insert text "Variance"
in "B,row#", then in each column C-N insert a formula that subtracts the
value in the Budget row from the Value in the Actual row. Then insert a
blank row beneath the Variance row. I have 1400 rows to process.
existing row, insert text "Actual" in "B,row#" at EVERY line (so I can key in
actuals), then insert a row BELOW the existing data, insert text "Variance"
in "B,row#", then in each column C-N insert a formula that subtracts the
value in the Budget row from the Value in the Actual row. Then insert a
blank row beneath the Variance row. I have 1400 rows to process.