Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto numbering
hello. i want to start a quotation template. i need to have a system whereby
a cell generates a quote number everytime i open the template and obviously it needs to be incremental.if the template ends up being cancelled and not saved then the number is not used untill next time i open the template and save it. how do i go about this. i have looked up all my help files but can't find anything. thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto numbering
Try this, Joe: http://vbaexpress.com/kb/getarticle.php?kb_id=56
************ Hope it helps! Anne Troy www.OfficeArticles.com "Joe Black" wrote in message ... hello. i want to start a quotation template. i need to have a system whereby a cell generates a quote number everytime i open the template and obviously it needs to be incremental.if the template ends up being cancelled and not saved then the number is not used untill next time i open the template and save it. how do i go about this. i have looked up all my help files but can't find anything. thank you |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto numbering
im having a little trouble getting it to work.. im obviously doing something
wrong. is it ment for excel? "Joe Black" wrote: hello. i want to start a quotation template. i need to have a system whereby a cell generates a quote number everytime i open the template and obviously it needs to be incremental.if the template ends up being cancelled and not saved then the number is not used untill next time i open the template and save it. how do i go about this. i have looked up all my help files but can't find anything. thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto numbering excell form | Excel Discussion (Misc queries) | |||
Auto Numbering | New Users to Excel | |||
Auto Numbering Each Cell In A Column | Excel Worksheet Functions | |||
Auto page numbering for several worksheets | Excel Worksheet Functions | |||
AUTO PAGE NUMBERING DIFFERENTLY FOR A WORKBOOK | Excel Worksheet Functions |