ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   document numbering (https://www.excelbanter.com/excel-discussion-misc-queries/186529-document-numbering.html)

des-sa

document numbering
 
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?



David Biddulph[_2_]

document numbering
 
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?






All times are GMT +1. The time now is 12:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com