|Hey, thanks for your question|
The plan is that the sheet 1 in book 1 is used as a template, while Book 2 will be used for a year at a time, I will for example have a "bok2" for 2012 a "Book 2" for 2013 and forward. "Book 2 will contain approximately 500 sheets.
Want it to work something like this:
When you press "save", copy sheet 1 to the first available sheets in book 2, and data in book 1 is cleared.
If Book 2 is full, a message box "Book 2 is full"
Velldig grateful if someone can post code examples