Hi Thanks for the file, however when i am opening this file i am getting run time error 1004 and giving me an option to debug , when i clicked on dbug it is highlighting
wksTarget.Cells.Locked = False in the code. sorry to bother you again and again. i wants the lock range C3:P12.

Thanks
Rajesh