Autogenerate alphanumeric ID numbers in Excel?
Solved
NoTechKnowledge64
-
Feb 25, 2022 at 03:14 PM
vcoolio
vcoolio
- Posts
- 1345
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- May 20, 2022
Related:
- Generate unique alphanumeric id in excel
- Auto generate id number in excel - Best answers
- Excel increment alphanumeric text ✓ - Forum - Office Software
- Excel - To generate unique ID ✓ - Forum - Excel
- How to add alphanumeric in excel - Forum - Windows
- Want to increment a Alphanumeric value in a range of cells - Forum - Excel
- Transfer data from one excel worksheet to another automatically - Guide
3 replies
vcoolio
Feb 26, 2022 at 05:38 AM
- Posts
- 1345
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- May 20, 2022
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.
vcoolio
Mar 2, 2022 at 05:26 PM
- Posts
- 1345
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- May 20, 2022
Mar 2, 2022 at 05:26 PM
You're welcome NTK. I'm glad to have been able to assist.
Good luck with your project.
Cheerio,
vcoolio.
Good luck with your project.
Cheerio,
vcoolio.