Thanks a ton..it did worked!! I need one change in this...If my columns get increased from current 11 to 15 in input sheet, what part of the code need to be changed? If you could help me with this, it would be great..!!

---------- Post added at 10:29 PM ---------- Previous post was at 10:23 PM ----------

Mike,

I did some trial & error on the code and it is working as per my requirement now. Thanks a ton.