ExcelSuduko
New Member
- Joined
- Apr 3, 2013
- Messages
- 5
Hopefully, I can explain this correctly.
I have a user with an (Excel) form that requires a unique ID number on each form. Even though the form is the same, each completed form has its owns unique ID number, so that it can be tracked. And yes, this is required for reasons that I cannot explain here.
At the present, the user has 100 versions of the same form, on the same sheet tab, in the file. When they need to print more copies of this form, they first must manually change the unique ID number on each version of the form, based on the next range of numbers to be used. This is both time consuming on 2 different fronts - first, manually changing the numbers, and secondly, when the actual form needs to be revised, every single copy of the form has to be changed, and that takes a lot of time, especially if new rows or columns are added.
While I cannot swear to it, I believe I have seen a similar type of process, where there is just one form, and then off to the side of the “single” form, there would be two (2) entry fields, that would be labeled: 'ID Range'. In those fields, the user would input the ID range. For example: 4952 to 5052. Then, when printing off the form, they would select 100 copies (as an example, if the range inputted covered that many numbers), and each copy would be printed, in sequential order, with the unique ID number specific to the range indicated. 4952, 4953, 4954, etc...up through 5052 (using my example ID range).
And yes, at some point I would like to migrate this form into a different system, such as SQL or Access, but that is still a ways off, as this form is actually completed non-electronically due to the nature of its purpose.
Thanks for any assistance!
I have a user with an (Excel) form that requires a unique ID number on each form. Even though the form is the same, each completed form has its owns unique ID number, so that it can be tracked. And yes, this is required for reasons that I cannot explain here.
At the present, the user has 100 versions of the same form, on the same sheet tab, in the file. When they need to print more copies of this form, they first must manually change the unique ID number on each version of the form, based on the next range of numbers to be used. This is both time consuming on 2 different fronts - first, manually changing the numbers, and secondly, when the actual form needs to be revised, every single copy of the form has to be changed, and that takes a lot of time, especially if new rows or columns are added.
While I cannot swear to it, I believe I have seen a similar type of process, where there is just one form, and then off to the side of the “single” form, there would be two (2) entry fields, that would be labeled: 'ID Range'. In those fields, the user would input the ID range. For example: 4952 to 5052. Then, when printing off the form, they would select 100 copies (as an example, if the range inputted covered that many numbers), and each copy would be printed, in sequential order, with the unique ID number specific to the range indicated. 4952, 4953, 4954, etc...up through 5052 (using my example ID range).
And yes, at some point I would like to migrate this form into a different system, such as SQL or Access, but that is still a ways off, as this form is actually completed non-electronically due to the nature of its purpose.
Thanks for any assistance!