ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   How do I insert multiple copies of an template in one workbook? (https://www.excelbanter.com/setting-up-configuration-excel/182711-how-do-i-insert-multiple-copies-template-one-workbook.html)

hprovost

How do I insert multiple copies of an template in one workbook?
 
I am trying to set up a workbook of sales invoices using a downloaded
template. Help!

Gord Dibben

How do I insert multiple copies of an template in one workbook?
 
A workbook Template is just that............a workbook.

Normally one opens a copy of the Template for each single sales invoice he
writes and saves the copy and writes the invoice data to a database using the
Template Wizard with Data Tracking Add-in.

If you just want a series of worksheets for invoices in one workbook, don't use
a Template.

Just copy the sheet from your downloaded Template to a new workbook and copy it
a whole bunch of times in the one workbook.

Use each copied sheet for an invoice.


Gord Dibben MS Excel MVP

On Sun, 6 Apr 2008 17:02:01 -0700, hprovost
wrote:

I am trying to set up a workbook of sales invoices using a downloaded
template. Help!




All times are GMT +1. The time now is 04:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com