automatic unique id number

[Mitch90]

when I create a new row it should get a unique number depending on the priority. for example if I select "1. High" under Priority the number should start with H followed by 4 digits. For "2. Medium" with M followed by 4 digits. and for "3. Low" with L followed by 4 digits. the workbook already sorts the rows automatically by priority and mechanic. when a point is processed it is automatically moved down. so the rows jump quite a bit. does anyone know how I can apply this? thanks in advance

 

[Joe4]

Welcome to the Board!

I was going to say, you could use a formula, but that will probably not work if rows may be moving around, as the formula will be re-calculated every time the row is moved and won't be static.
If you want to create ID numbers that are unique and do not change, regardless of whether or not rows move around, you will need to enlist the use of VBA.
Are you agreeable to using a VBA solution (otherwise, I don't know how you are going to do this, if not manually)?

If so, can you answer this question. Are individual rows ever deleted, or only moved/added?

 

[kvsrinivasamurthy]

How four digits are decided. It needs Worksheet event VBA code.