Home |
Search |
Today's Posts |
#1
|
|||
|
|||
saving dates\invoice numbers
Hi, I don't know how to to get excel to open\save an invoice from which the
date it was writen? eg. I have a date formula on a invoice template I downloaded and modified, if I save it on the date it was writen and open it again sometime later, it shows the present date. Also I would like to know how to insert invoice numbers automatically one after the other? eg. 00001 and then the next invoice I issue 00002 and so on. I would like the date to be the present date however when I start a new invoice. Thanks ever so much. -- Message posted via http://www.officekb.com |
#2
|
|||
|
|||
You would need an event macro to increment the invoice number. The event to
use is your choice. File opening? Invoice printing? Something else? The same macro can insert the current date in a cell such that the date will not be volatile. Post back and tell us what you want to use as the event to trigger the invoice number incrementing. HTH Otto "R S via OfficeKB.com" wrote in message ... Hi, I don't know how to to get excel to open\save an invoice from which the date it was writen? eg. I have a date formula on a invoice template I downloaded and modified, if I save it on the date it was writen and open it again sometime later, it shows the present date. Also I would like to know how to insert invoice numbers automatically one after the other? eg. 00001 and then the next invoice I issue 00002 and so on. I would like the date to be the present date however when I start a new invoice. Thanks ever so much. -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Match Last Occurrence of two numbers and Return Date | Excel Worksheet Functions | |||
Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
Count and Sum Total occurrances of two specific numbers | Excel Worksheet Functions | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) |