How do I copy a sheet in excel to another excel file with the format retained exactly from the source sheet to the destination sheet?


I have tried to do so but the format always gets corrupted. I need to retain the formatting of the source sheet when I copy the same to the destination sheet.