saving dates\invoice numbers

  • Thread starter R S via OfficeKB.com
  • Start date
R

R S via OfficeKB.com

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.
 
O

Otto Moehrbach

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

template creates invoice - how to create summary worksheet? 13
Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4
Data Validation to exclude blank cells 6
Invoice with percent complete 2
excel macro 1
Invoice due; Payment terms 5
Invoice Numbers 3
set the numbers on the invoice template 1

Top