Hi,
I am looking to do an auto generated unique number (letters and numbers) in column A when I enter a date into column B. I have attached a sample of what I am looking for.
Thank you
Hi,
I am looking to do an auto generated unique number (letters and numbers) in column A when I enter a date into column B. I have attached a sample of what I am looking for.
Thank you
Per your sample workbook, try this in A2 and drag/copy down
Formula:Please Login or Register to view this content.
May not be the best solution but it works.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Could be done formulaically (in A2 copied down):
=IF([@Date]="","","XXX"&TEXT(ROW()-1,"0000"))
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thank you, I was making this way harder than it needed to be!
You're welcome!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Here's event code for the sheet module:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks