ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   customer billing (https://www.excelbanter.com/new-users-excel/38187-customer-billing.html)

EssEss

customer billing
 
Hello....

I am having trouble with a template I made for my monthly customer billing
statements, I cant seem to save it for multiple customers. I've saved it as
..xls, template, workbook,spreadsheet, etc... When I add or update customer
data it will save the information and then my "original template" is gone. I
knlw there has to be a simple soultion.. I just can't get it for some reason.

Thank You,

S.S.

Bob Phillips

You should create a template as an xlt file, store that in the templates
directory. When you get a new customer, open it via FileNew, and save that
as Customernnn.xls in some customer directory.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"EssEss" wrote in message
...
Hello....

I am having trouble with a template I made for my monthly customer

billing
statements, I cant seem to save it for multiple customers. I've saved it

as
.xls, template, workbook,spreadsheet, etc... When I add or update

customer
data it will save the information and then my "original template" is gone.

I
knlw there has to be a simple soultion.. I just can't get it for some

reason.

Thank You,

S.S.




EssEss



Thank You so much.... You have no idea how many hours this will save me!

Thank You, Thank You, Thank You,

EssEss


All times are GMT +1. The time now is 02:26 PM.

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