Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Gwyneth
 
Posts: n/a
Default Increment an Invoice number

I find all this very confusing - I am not that computer literate. How do I
save the last invoice number to a cell - will it automatically change with
each new invoice or will I have to type it in each time?

" wrote:

Depending on the complexity of use required, you can save
last invoice number to a cell (or add it to a list of
numbers), then simply add the increment to that number for
the new invoice.


-----Original Message-----
I have an Invoice template, which is used with SaveAs to

create a new invoice. Can the invoice numbers be
automatically incremented?
--
Les
.


  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi

if you'ld like to email me (julied_ng at hcts dot net dot au) direct i can
send you a sample workbook, that you might be able to adapt to your needs ..

Cheers
JulieD

"Gwyneth" wrote in message
...
I find all this very confusing - I am not that computer literate. How do I
save the last invoice number to a cell - will it automatically change with
each new invoice or will I have to type it in each time?

" wrote:

Depending on the complexity of use required, you can save
last invoice number to a cell (or add it to a list of
numbers), then simply add the increment to that number for
the new invoice.


-----Original Message-----
I have an Invoice template, which is used with SaveAs to

create a new invoice. Can the invoice numbers be
automatically incremented?
--
Les
.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 09:02 PM
Automatic Invoice Number mb Excel Discussion (Misc queries) 1 January 22nd 05 11:48 PM
How do I automatically pull a new invoice number into an excel te. Hube Excel Discussion (Misc queries) 3 December 29th 04 12:27 AM
How to format a number in Indian style in Excel? Victor_alb Excel Discussion (Misc queries) 2 December 21st 04 05:21 AM
Convert week number into calendar month? WickyWick Excel Worksheet Functions 2 November 9th 04 10:01 PM


All times are GMT +1. The time now is 04:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"