Hi,
I'm sure this is easy to do...
I would like a document with 2 sheets (Sheet1 and Sheet2). Sheet2 would essentially be a template for Sheet1 which would be the working sheet. Sheet1 would a button on it which grabs all of the content on Sheet2 and copies it to Sheet1.
(Sheet1 would then get edited, printed, and we need to start again with the button to get the template back.)
Sheet1: Working sheet
Sheet2: Established template
Copy Sheet2 to Sheet1 > Edit Sheet1 > Print Sheet1 > Copy Sheet2 to Sheet1...etc.
Make sense?
Is this possible? Even better, is it possible WITHOUT Macros or VBA?
I'm pretty new to macros, so if you post a solution, can you please detail how to include it in a button on sheet1!!! (and i guess on the template that you copy it from)!
Thanks!!
Bookmarks