Greetings to all my excel gurus and VBA high masters;
I would like to create a VBA code that responds to a command button. The code would basically create a brand new sheet identical to the original sheet prior to any alterations. So for example:
If sheet one is a form that needs to be filled out--which starts off blank--once it has been completed the user can hit the "create new form" button (if he/she needs to complete another form) and a new sheet with a blank form and a "create new form" button will pop up.
So far I'm hitting walls here and I'm not even sure where to begin.
You're wisdom and advice would be greatly appreciated.
Thank you Gurus & VBA masters