Hi
I need a VBA macro to be run when I open a formatted file (attached) which can have between 1 and 1000 rows. Actions:
1-delete column A
(note the column name below are the current name in the sample file)
2-insert a column between I and J; Title of the column is Total; formula to be inserted in all cells of this new column: sum of H + I cells
3-insert a column between K and L; Title of the column is Total; formula to be inserted in all cells of this new column: sum of J + K cells
4-insert a column between M and N; Title of the column is Total; formula to be inserted in all cells of this new column: sum of L + M cells
5-insert a column between O and P; Title of the column is Total; formula to be inserted in all cells of this new column: sum of N +O cells
6-insert a column between Q and R; Title of the column is Total; formula to be inserted in all cells of this new column: sum of P + Q cells
7-insert a column between S and T; Title of the column is Total; formula to be inserted in all cells of this new column: sum of R + S cells