Can Excel be used as a invoicing package

[MrMcFestoe]

Need some help or ideas, i am trying to create a new invoicing package which needs to be simple to use for me, i have created a sheet in excel which is locked and allows data to be entered, now for the hard part.

What iam trying to do is have a worksheet for each month and when a invoice is raised it will be filed in that months worksheet, is this possible ?

Also not managed to get autonumber working, how do you do this for excel, trying to have a unige number for all invoices starting with the date e.g 291103-000001.

Could somebody let me know if iam on the wrong track or if this is possible.

 

[Dreamboat]

Actually, your app has already been created by me and my coder, and is available for free download.

It's called MyInvoicing.xls

And it's downloadable from here:

http://www.theofficeexperts.com/downloads.htm#ExcelDownloads

Anne Troy

http://www.VBAExpress.com