Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Database > auto fill invoice numbers

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

auto fill invoice numbers

Reply to Message Icon

Name: lcperry1959
Date: April 20, 2009 at 09:40:25 Pacific
OS: Windows XP
Subcategory: General
Comment:

Is there a formula for using an invoice template that will auto fill the invoice number when a new one is opened?



Sponsored Link
Ads by Google

Response Number 1
Name: angrymen2001
Date: April 20, 2009 at 17:46:34 Pacific
Reply:

What database program are you using?

What happened to my quote


0

Response Number 2
Name: lcperry1959
Date: April 21, 2009 at 04:49:56 Pacific
Reply:

I'm sorry, Excel


0

Response Number 3
Name: angrymen2001
Date: April 21, 2009 at 19:34:39 Pacific
Reply:

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


0

Response Number 4
Name: lcperry1959
Date: April 22, 2009 at 05:35:21 Pacific
Reply:

Thanks for trying. This template came from Microsoft Excel Templates. I'll try to find that again.


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More


Use following form to reply to current message:

Login or Register to Reply
LoginRegister


Sponsored links
Ads by Google


Results for: auto fill invoice numbers
Designing Check Printing System www.computing.net/answers/dbase/designing-check-printing-system/29.html

Field Question www.computing.net/answers/dbase/field-question/67.html

Auto fill in data in access 2007 www.computing.net/answers/dbase/auto-fill-in-data-in-access-2007/505.html