EXCEL HELP NEEDED

pinkhippo

Hi,
I have designed an invoice in excel to send out to clients. I have been told that excel can generate an invoice number automatically. At the moment i am manually putting it in. ie: INV1000020.

Also i would like the date to be inserted automatically to the date i do the invoice.

Any ideas/help will be greatly appreciated.;)

Apple Orange

Don't know about automatically generating the invoice number, but I know the date can be automatically input with

=TODAY()

bruce wayne

As Apple Orange said =today() will always give you todays date, as for incremental invoice numbers it is possible. I found this via google

Let's say the "invoice" cell is A1. You need to put this code in the workbook's _Open event and it will do what you need. To get access to that event, from Excel press Alt+F11 which will start the VBA editor. Once it opens, press CTRL+R to show the Project Explorer. Find and double click the line that says VBAProject(<yourfilename>.xls) where <yourfilename> is the saved name of your file. Then, find and double click 'ThisWorkbook'. In the window that appears on the right, paste in the code below. Press Alt+F11 to get back to Excel, then save and close the file. When it opens again, cell A1 will be one value higher than before.

XK

Private Sub Workbook_Open()
Range("a1").Value = Range("a1").Value + 1
End Sub

good luck ;0)

pinkhippo

Thanks a million:D

bruce wayne

would you consider a free web based version ? something like freshbooks zoho invoicing or something from the google apps marketplace?

pinkhippo

I have a programme called softline pastel which is grand ,sometimes i have to use my own invoices and for that im happy with excel. Thanks though.