How do you do....it? Thread, Re: Generate the next available number in Technical; Do you know of any program, or template which will help me generate the next available number. We have numbers ...
15th August 2011, 12:34 PM #1
- Rep Power
Re: Generate the next available number
Do you know of any program, or template which will help me generate the next available number. We have numbers for PC like 001, 002, 005, 008 now if I need to add a new number, I want the program to give me either 006/007/009.
Thank you for your support!
15th August 2011, 12:42 PM #2
In what context? Do you want just a counter in a spreadsheet? script? Do you want it to automatically read AD? Or what?
15th August 2011, 01:26 PM #3
- Rep Power
Thanks for your response steve21. I'm a novice at this. I need any program or templete which is easy to use. The program must generate the next available number automatically. Is there anything that I can use withought the codes? If not which one can you recommend for a begginer. Thanks
15th August 2011, 02:43 PM #4
Easiest way to do it would be something like this in excel:
Do Until ActiveCell = "STOP"
If ActiveCell = "" Then
a = ActiveCell.Row
ActiveCell = "Used"
ActiveCell = a
Will search through the column of numbers, finding the next free one. It'll then post that number in A1, and fill in the spot so next time you search it'll find next one etc etc. (STOP just breaks it out of the loop so it doesn't go on forever )
Example spreadsheet attached, (Note needs macro enabled)
By Halfmad in forum General Chat
Last Post: 8th August 2007, 12:56 AM
By e_g_r in forum Wireless Networks
Last Post: 17th September 2006, 11:24 PM
By Ric_ in forum General EduGeek News/Announcements
Last Post: 30th May 2006, 03:30 AM
By Dos_Box in forum General EduGeek News/Announcements
Last Post: 26th August 2005, 08:54 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)