Hi. I am building a quotation system in Excel and have to file away, and be
able to bring back up specific quotations. To do this, I presume I need a
unique quotation number. How best should I do this? Thanks

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"flymeoutofhere" wrote in message
...
| Hi. I am building a quotation system in Excel and have to file away, and be
| able to bring back up specific quotations. To do this, I presume I need a
| unique quotation number. How best should I do this? Thanks

its easy
You need a quotes"register" where the quote details are filled out,ie
name,adress etc etc,and this is where the number generated and kept.When you
need to retrive a quote you can search the register(also a excel sheet) so
you can find the quote for Mr Blogs of 67 somewhere street,and find it is
quote number 5007.I used to run a system where the number was actually
generated from a BOOK.In this way someone who doesnt always have access to
the computer system can find a quote number without bugging you to find
it!.Keep the system simple maybe the date with an extra number or
something.If its logical and simple it will make filing and finding the
quotes easy for everyone
--
paul

remove nospam for email addy!



"Niek Otten" wrote:

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"flymeoutofhere" wrote in message
...
| Hi. I am building a quotation system in Excel and have to file away, and be
| able to bring back up specific quotations. To do this, I presume I need a
| unique quotation number. How best should I do this? Thanks