@ Marcol,

I have reviewed your solution you wrote a quite comprehensive macro for the golf sheet, i also used a macro to do so if convenient for you would you see that file which i enclosed and have a look at macro and comment if it has any limitation as far as i felt it is doing the job. But for my understanding if you appreciate & comment.

I hope your response would also be beneficial for timparker to understand the difference between two solutions available with him.

Regards,