Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-02-2024, 10:26 AM
SnakeDoctor's Avatar
SnakeDoctor SnakeDoctor is offline Unique, Sequential, Alpha-Numeric Number Generation for Projects Windows 11 Unique, Sequential, Alpha-Numeric Number Generation for Projects Office 2021
Advanced Beginner
Unique, Sequential, Alpha-Numeric Number Generation for Projects
 
Join Date: Jul 2023
Location: Ft. Worth, TX
Posts: 38
SnakeDoctor is on a distinguished road
Default Unique, Sequential, Alpha-Numeric Number Generation for Projects

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!
Reply With Quote
 



Similar Threads
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
Unique, Sequential, Alpha-Numeric Number Generation for Projects How to do an alpha numeric Sort By? Opul3nce Excel 1 10-15-2012 11:11 PM
Unique, Sequential, Alpha-Numeric Number Generation for Projects [How To] Generate Alpha Numeric Values in Excel 2010 stnicholas81 Excel 1 07-25-2011 01:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:10 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft