I would like to add something (formula) to the following code to automatically add a new ID number with each new entry. Some of the entries will have the same name but each time a new entry is added I want the ID number to increase by 1. Assume that the first entry is 0001.
Thank You
Jim O
Please Login or Register to view this content.
Last edited by JOGIER; 07-15-2009 at 05:19 PM.
Add it where? Maybe like this to add it to column U:
Please Login or Register to view this content.
Last edited by JBeaucaire; 07-15-2009 at 04:14 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Sorry, I forget to say what column. I would like it to be column "A".
Jim O
It works but I would like to format the numbers to 0001. I tried to format the column but the number keeps reverting to a single digit.
Jim O
Highlight the entire COLUMN and format as 00000. That works fine. The macro I gave is inserting VALUE only, it is not affecting the existing number format of the cell in any way.
That works very well.
Thank You.
Jim O
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks