ExcelBanter - Incrementing a form

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Incrementing a form (https://www.excelbanter.com/excel-discussion-misc-queries/153999-incrementing-form.html)

TheNose

Incrementing a form

I created a form that will be used by many users. How can I increment the
form number so that every user on the network can use the template but the
form number will never be the same. I can store the number on the network
drive. Any ideas?

Thanks,

Terry

Jim Thomlinson

Incrementing a form

Check out this link...
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
--
HTH...

Jim Thomlinson

"TheNose" wrote:

I created a form that will be used by many users. How can I increment the
form number so that every user on the network can use the template but the
form number will never be the same. I can store the number on the network
drive. Any ideas?

Thanks,

Terry

TheNose

Incrementing a form

Thanks for the help Jim. It works great!

Terry

"Jim Thomlinson" wrote:

Check out this link...
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
--
HTH...

Jim Thomlinson

"TheNose" wrote:

I created a form that will be used by many users. How can I increment the
form number so that every user on the network can use the template but the
form number will never be the same. I can store the number on the network
drive. Any ideas?

Thanks,

Terry

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