Pestomania
Active Member
- Joined
- May 30, 2018
- Messages
- 292
- Office Version
- 365
- Platform
- Windows
This may be a dumb questions, but any help is appreciated.
I am working with a table that has 3 columns, below is an example:
I am trying to find a way that when "Department" is filled in, the unique code will auto fill with the department abbreviations (vlookup from "Department Abbreviations" tab) and chooses the next unique identifier in the sequence. Everything I do makes it change the numbers when I sort the table which should not happen.
I know Microsoft Access creates the databases with auto numbers that do not change no matter how you sort it. Is there a way to create this in Excel?
I am working with a table that has 3 columns, below is an example:
I am trying to find a way that when "Department" is filled in, the unique code will auto fill with the department abbreviations (vlookup from "Department Abbreviations" tab) and chooses the next unique identifier in the sequence. Everything I do makes it change the numbers when I sort the table which should not happen.
I know Microsoft Access creates the databases with auto numbers that do not change no matter how you sort it. Is there a way to create this in Excel?
Department | Unique Code | Description |
Facilities | FACT-1001 | Test 1 |
Facilities | FACT-1002 | Test 2 |
Production | PROD-1001 | Test 3 |
Facilities | FACT-1003 | Test 4 |