Hi all - I think somebody will enjoy working this out:-
I have a work spreadsheet that has a list of projects that I am to work on and In column J I prioritise each project 1,2,3 etc. In coulmn D there is data validation and I would like to automatically renumber the priority column the...