Sir,
Can anybody help me in writing vba code for excel to generate automated alphanumeric code having first entry as L,P,G,T(based on a condition), next four numbers starting from 0001 and last four as mmyy format for the current month and year. The code should be unique and increasing in pattern and should serve 20-25 users working at a time connected through internet/intranet/LAN.
Rgds,
Pankaj
Not really, workbooks aren't really synced like that, I don't know if you could guarantee the numbers would be unique without a central file/database or without using guids
Copy paste the below formula in a cell
=TEXT(ROWS($1:1),"L0000")&TEXT(TODAY(),"MMYY")
Drag it down...
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
@sixthsense, how does that work when it needs to be unique across 25 users?
If the workbook is in shared mode lolOriginally Posted by Kyle123
Shared workbooks should all be burnt. Especially if you have 25 concurrent userslol
I accept it but I recall our earlier discussion about shared workbook and I managed to work with 30 users also but it requires proper usage / maintenance
eugh rather you than me
Thanx all for your input. The file would be on sharing mode. @sixthsence, your suggestion works well beginning with L only, but the alphanumeric code should begin with Either of L,P,G or W based on a condition.
Rgds,
@Kyle123, could you please help me writing the vba for choosing first number appearing against an empty cell. Let me make myself more clear. I want a vba coding for chosing a number appearing against available empty cell. Rgds,
Without knowing that condition we cant give you the exact solution
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks