Possible to make a button that copies a sheet and changes certain values in the new sheet?

enanthate

New Member
Joined
Jan 6, 2016
Messages
9
Hi,

When sending an invoice for work done, I use excel to set up an "installment nota" so that the customer has a complete overview of the amounts that are being paid for this month, in addition to the total accumulated charges since the project started.

So the workbook usually ends up being Page1, Page2, Page3,.... for each month that I send an invoice.

Just as an example, on all the pages, the cell "previously charged" links to the page before. If we're on installment 3 (Page3), then the cell "previously charged" links to the same cell on (Page2).

So every time a new month comes, I copy the entire sheet then go through the cells that were linked to the previous month and change them to the month before.

For example, I am making a new bill which will be month 5.
1. I copy "Page4" and name it "Page5".
2. I go through all the cells that are linked to "Page3" and link them to "Page4".

I then the correct accumulated and "previously charged" amount.

Any suggestions?
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
I can upload an example of one of the workbooks. I'm not sure how this can be done though, doesnlt look like I can upload attachments here?
 
Upvote 0
For example:

khkY6G
 
Upvote 0

Forum statistics

Threads
1,223,234
Messages
6,170,891
Members
452,366
Latest member
TePunaBloke

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top