Hello!

I'm fairly new to VBA so any help would be much appreciated.

I have a worksheet and I want to put a button at the bottom that says 'add next date.' When clicked, I'd like it to copy the sheet and move it to the end and rename it to the next number (date) in the sequence. For example, the first sheet is called '1' and when the button on it is clicked it will duplicate it and rename it '2.'

Please can anyone help me with this or point me in the right direction of some tutorials that might help?

Thank you!