Hi Jolivanes,
Thanks for your quick response...But it’s not working as per the requirement. Little issue is there which I tried to find out but no luck.
1. The data is over writing the last row of (from 2nd column) of other sheet.
2. The heading is also copying, which is not required.
3. It’s throwing error when I am running a macro “error 424- object required”.
Could you please explain how the code is working?
Thanks...