Quote Originally Posted by arbrahul View Post
Perfect as I wanted. Thank you verymuch. I liked the name you have given to the sheet as well.

Thank you once again.
Hello ravi, I tried this and works with my sheet perfectly. But when I use the same macro for a sheet with 6 columns it is not working properly.. I tried to make modifications but without success. Now my xcel sheet has one more column after the fifth one and it is for 'learning'. Now column 1 code, 2 name, 3,4,5 are goal, target, progress and new column 6 for learning. Can you help me plsss... Sorry but i dont know anything in macro...