I need help setting up a macro for a billing form I use for work.
I need when I click a button, it recreates a copy of that same excel sheet, but I need the numbers from a certain column(sheet 2; column e13:E21) to slide over a column(to D13:D21) and also be added to the value thats in that current cell already for the copy of the excel sheet. If it helps, I can upload the template to make it easier to write the macro. Essentially this is allowing me to prepare next months billing without having to manually add the two amounts and manually zero out anything from a previous month's bill.
Any guidance would be appreciated and I hope I wrote it out to where you could understand what I need down
I need when I click a button, it recreates a copy of that same excel sheet, but I need the numbers from a certain column(sheet 2; column e13:E21) to slide over a column(to D13:D21) and also be added to the value thats in that current cell already for the copy of the excel sheet. If it helps, I can upload the template to make it easier to write the macro. Essentially this is allowing me to prepare next months billing without having to manually add the two amounts and manually zero out anything from a previous month's bill.
Any guidance would be appreciated and I hope I wrote it out to where you could understand what I need down
