creating an invoice

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Naomi Hall - 21 Mar 2005 22:07 GMT

It has been a long time since I have used excel. I know that I had a
invoice set up so that each time I opened a new invoice all of my company
info was saved on it and it was in numerical sequence, 101,102,103.....
Can someone please tell me how i did that so I can set it up again. It has
been so long and i have lost my patience and am very frustrated.

Reply to this Message

Paul B - 21 Mar 2005 23:19 GMT

Naomi, have a look here
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

Signature

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

> It has been a long time since I have used excel. I know that I had a
> invoice set up so that each time I opened a new invoice all of my company
> info was saved on it and it was in numerical sequence, 101,102,103.....
> Can someone please tell me how i did that so I can set it up again. It has
> been so long and i have lost my patience and am very frustrated.

Reply to this Message

Gord Dibben - 22 Mar 2005 00:55 GMT

Naomi

What are you looking for?

An invoice template or the sequential numbers?

The Template should be under File>New...Templates>Spreadsheet Solutions.

You will need the TMPLTNUM.XLA in your Office Library.

If don't have TMPLTNUM.XLA(2002 and 2003 don't have it with their invoices).

For the sequential numbers see JE McGimpsey's site.

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

Gord Dibben Excel MVP

>It has been a long time since I have used excel. I know that I had a
>invoice set up so that each time I opened a new invoice all of my company
>info was saved on it and it was in numerical sequence, 101,102,103.....
>Can someone please tell me how i did that so I can set it up again. It has
>been so long and i have lost my patience and am very frustrated.

Reply to this Message