Retain format settings

[tjc154]

Is there a macro that can retain formatting when copying data to another worksheet or workbook? I’m running a macro that exports data between two workbooks. When the data is copied to the destination workbook, I lose the header information and the formatting is different.

I would like it to retain the header information, row height, column width, font type and size on the destination worksheet.

Is this possible?

Thank you
Tom

 

[Jaafar Tribak]

Is there a macro that can retain formatting when copying data to another worksheet or workbook? I’m running a macro that exports data between two workbooks. When the data is copied to the destination workbook, I lose the header information and the formatting is different.

I would like it to retain the header information, row height, column width, font type and size on the destination worksheet.

Is this possible?

Thank you
Tom

How about copying the whole worksheet ?