http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
--
David Biddulph
"des-sa" wrote in message
...
please help again
i have a worksheet which i use as a template for giving quotes to
customers
on a daily basis. around 20 quotes are given per day. i want to use this
template to be reproduced (copied) each time i have to quote. my 1st
question is: how do i "force" a unique document number, preferably
consequtive, for each new document created from the template?