If this is something you will do a lot, create a copy of your workbook,
delete all sheets except one that has an empty invoice structure and save it
as a Template in the Templates folder. Then when you need a new invoice
sheet, right-click a sheet tab, click Insert, and then insert a new
worksheet based on your Invoice template.
Additionally, the best way to copy an entire sheet and preserve your
settings is right-click a sheet tab and use the Move or Copy command.
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.
~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
Co-author of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/books/9801.aspx#AboutTheBook
Word FAQ:
http://mvps.org/word
TechTrax eZine:
http://mousetrax.com/techtrax/
MVP FAQ site:
http://mvps.org/