Macro to add new sheet that copies previous

[masbery]

Hello,

I need to create a workbook for monthly wages that has a summary sheet at the start with each months wages total. The first months wages sheet will be created manually to make sure that all the required info is there. As this is an organic thing and people are added and removed constantly i can't just create 12 sheets with the same information on, someone might be missed from one month to the next if they haven't been added / removed from the previous month if you see what i mean.

Hence I then need to make a button which copies the last sheets information onto a new sheet, but at the same time creates a link to the summary sheet so that the total from that month appears on the summary sheet. These totals will then be added up to give the years total wages.

Unfortunately I've little / no experience with VB so will need some help with all of this.

Many thanks.

Mark.

 

[masbery]

Having thought about it, you could have a master sheet that you do all of the modifications to, then the 12 other sheets automatically update from this one, but if you have already entered wage information on some of the sheets this won't be affected. Not sure which method would be easier.

Thoughts / suggestions greatly appreciated.