![]() |
#1
|
||||
|
||||
![]()
I've been searching the web for a way to generate a unique, sequential alpha-numeric value (i.e., MFTP001, MFTP002, etc.) for each new 'project' entered into a worksheet.
The generated value needs to be permanently 'assigned' to that project and not change throughout its lifespan, regardless of the addition/deletion of rows around it. Ideally, the value will populate its cell when a value in entered into one of four other cells on the same row (e.g., different project types). So far, everything I have found only covers 'dumb' sequential numbering or numbering of rows 1 through whatever, that auto-number when a row is added or deleted. Is this possible? Thanks in advance! |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Some alpha/numeric data missing when I run MS Query | Baldeagle | Excel Programming | 1 | 01-28-2015 01:00 PM |
first character NOT Alpha numeric or Tilde (~) delete. | ksridh | Word VBA | 5 | 03-17-2014 12:45 AM |
Labeling sequential forms with a unique number | krau0231 | Word | 1 | 10-18-2012 03:33 PM |
![]() |
Opul3nce | Excel | 1 | 10-15-2012 11:11 PM |
![]() |
stnicholas81 | Excel | 1 | 07-25-2011 01:31 AM |