auto fill invoice numbers

April 20, 2009 at 09:40:25
Specs: Windows XP
Is there a formula for using an invoice template that will auto fill the invoice number when a new one is opened?

See More: auto fill invoice numbers

Report •


#1
April 20, 2009 at 17:46:34
What database program are you using?

What happened to my quote


Report •

#2
April 21, 2009 at 04:49:56
I'm sorry, Excel


Report •

#3
April 21, 2009 at 19:34:39
If I'm understanding you correctly, in your invoice number
column you want the following formula
=IF(B1>"",get the value from cell above + 1,"")
THis will automatically increment the invoice number as a new
one is entered.
Otherwise you might want to work with Access

What happened to my quote


Report •

Related Solutions

#4
April 22, 2009 at 05:35:21
Thanks for trying. This template came from Microsoft Excel Templates. I'll try to find that again.

Report •


Ask Question