Autogenerate alphanumeric ID numbers in Excel?
Solved/Closed
NoTechKnowledge64
-
Feb 25, 2022 at 03:14 PM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Mar 2, 2022 at 05:26 PM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Mar 2, 2022 at 05:26 PM
Related:
- Generate unique alphanumeric id in excel
- Auto generate id number in excel - Best answers
- Excel auto generate id - Best answers
- Excel generate unique id ✓ - Excel Forum
- Number to words in excel - Guide
- Position formula in excel ✓ - Office Software Forum
- Excel create unique id for each row ✓ - Excel Forum
- How to take screenshot in excel - Guide
3 responses
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Feb 26, 2022 at 05:38 AM
Feb 26, 2022 at 05:38 AM
Hello NTK,
I'm not sure how you'd want this set out in your worksheet, but you could start with this:-
In cell A1of your main worksheet, place the first ID you'd like to use; e.g LA1000
In a standard module, place the following code and assign it to a button:-
I've assumed your main sheet is sheet1 in the code.
Once you're done with 'LA1000', click on the button to bring up the next sequential ID number.
I've attached a sample workbook at the following link for you to have a look at:-
https://wetransfer.com/downloads/99fe083f98cf1166a3aaf94748aa465520220226103431/90577c
Click on the button to change the ID to the next sequential ID.
I hope that this helps.
Cheerio,
vcoolio.
I'm not sure how you'd want this set out in your worksheet, but you could start with this:-
In cell A1of your main worksheet, place the first ID you'd like to use; e.g LA1000
In a standard module, place the following code and assign it to a button:-
Sub CreatSequencedNos() Sheet1.[A1] = Left([A1], 2) & (Right([A1], 4) + 1) End Sub
I've assumed your main sheet is sheet1 in the code.
Once you're done with 'LA1000', click on the button to bring up the next sequential ID number.
I've attached a sample workbook at the following link for you to have a look at:-
https://wetransfer.com/downloads/99fe083f98cf1166a3aaf94748aa465520220226103431/90577c
Click on the button to change the ID to the next sequential ID.
I hope that this helps.
Cheerio,
vcoolio.