Automatic numbering

[hazchem]

Hola!
I'm in the middle of designing a spreadsheet for issuing quotes to my customers. I'm having a massive mental blank though when it comes to a formula for assigning a unique number automatically to each quote.
I'm trying to get the format -

ALxxxxxx

where x is a number sequence starting from 000006. I want that number to update itself automatically each time I create a new quote. any ideas or am i living in a dream world?

 

[anno]

hazchem
take a look at this thread:
http://www.mrexcel.com/board/viewtopic.php?topic=5682&forum=2
especially jack in the uk's suggestion about using invoice.xlt. looks like it has a facility for automatic numbering.
good luck

 

[hazchem]

d'oh! of course, invoice.xlt.

thanks muchly!

 

[hazchem]

grumble. for some reason, i get an error when i try to open invoice.xlt something about 'the macro is unable to be signed or disabled, therefore this workbook will not be opened under high security level'
So i'm guessing the network admins had something to do with that, which means my chance of getting it changed are bugger all. A similar thing happened when I tried to download the file in that thread you mentioned. any other ideas? PM me if you need to email me anything.

 

[anno]

hi hazchem
not sure what that's about but you're probably right - gotta love your sys admin!
i was going to post the code from invoice.xlt for the auto number thingy but it's password protected. can't think of anything else to do, expect saying pretty please to your system administrator...
anno

 

[RichardS]

Under the Tools menu, select Macro, then Security, and change the setting from High to Medium.

Richard

 

[royUK]

Hi
I think the code in invoice.xlt is protected.
I got round this problem by keeping a log of invoice/estimate numbers on a worksheet. It's not automatic, but it helps prevent duplications.I keep this log in the same workbook as my form and call up thr log's userform to enter relevant data by assigning this code to command button
Sub CommandButton1_Click()



Worksheets("DataBase").ShowDataForm




End Sub
Where the log is named database. A similar button can view data.

Hope this helps

 

[Jack in the UK]

Ermm.. i have idea that Excel 97 or was it Version 5 were open source!! or was that the loan XLT ??? Worth a try u will need a old copy of office / excel thou:

I have open souce Loan which dont help much, also try E97 templat even in locked might run better

 

[Jack in the UK]

Ermm.. i have idea that Excel 97 or was it Version 5 were open source!! or was that the loan XLT ??? Worth a try u will need a old copy of office / excel thou:

I have open souce Loan which dont help much, also try E97 templat even in locked might run better