Thank you very much. It worked perfectly. I really appreciated your help.

I need another help though related to this one also. Now that it is able to put x on column K, I would like to copy the value of cell K1 down to the cell where its marked "x".

Please help. Thank you.