I have created a billing statment on tab sheet 1 and saved it as a template.
I would like to fill in the template and save to tab sheet 2 and have sheet 1 zero out and have the infor saved to sheet 2
is this possible
Thanks
TS
I have created a billing statment on tab sheet 1 and saved it as a template.
I would like to fill in the template and save to tab sheet 2 and have sheet 1 zero out and have the infor saved to sheet 2
is this possible
Thanks
TS
You should leave the blank template on sheet 1, but use the Edit...Move or Copy menu to copy the template as another sheet in the workbook. This copy can then be used to complete the details and print off etc.
Alterntaively, save the blank template as an actual Excel template (using SaveAs) then for future billing templates use Excel's File & New... menu to open a new workbook based on the blank template.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks