Auto Increment Alpha Numeric ID

**sabeelahmedks** · 01-18-2018, 03:14 AM

hi, i have used a form to auto generate the unique ID from sheet1 with the below code.

Please Login or Register  to view this content.

it works fine for single alphabet in ID, but i need to have ID with multiple alphabet. for example ID="A18J001" till A18J it should be constant only last three digit need to be incremented. Please help me to clear this.
Many thanks in advance

I have attached my form and sheet for your better understanding.

auto-id.png

BR
Cool Sab

**jindon** · 01-18-2018, 03:26 AM

Please Login or Register  to view this content.

**sabeelahmedks** · 01-18-2018, 04:27 AM

Thanks a lot It works...!

**leelnich** · 01-18-2018, 04:28 AM

?? Why not:

Please Login or Register  to view this content.

**jindon** · 01-18-2018, 04:36 AM

Originally Posted by leelnich

?? Why not:

Original thread
https://www.excelforum.com/excel-pro...ll-number.html

Auto Increment Alpha Numeric ID

LinkBack

Thread Tools

Rate This Thread

Display

Auto Increment Alpha Numeric ID

Re: Auto Increment Alpha Numeric ID

Re: Auto Increment Alpha Numeric ID

Re: Auto Increment Alpha Numeric ID

Re: Auto Increment Alpha Numeric ID

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Return latest Alpha / Numeric / Numeric Alpha Revision

Excel 2010 - Userform - Vlookup, Alpha Numeric auto increment, send form to Outlook

How to implement Customer ID auto increment when using alpha numeric values with VBA

[SOLVED] Alpha & Numeric auto fill

alpha numeric data auto copy

Increment Alpha Numeric Cell

[SOLVED] Increment Alpha Numeric Cell

Bookmarks

Bookmarks

Posting Permissions