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