Copy a worksheet from one workbook into another but lost format

[YNUL]

When copy a worksheet from one workbook into another workbook, format like background-color will lost.
How to solve this?
Thanks.

[rahul.lakshmanan]

@YNUL pls check this

Copy a worksheet from one workbook into another but lost format

When copy a worksheet from one workbook into another workbook, format like background-color will lost. How to solve this? Thanks.

[AshwinS2 (Ashwin S)]

Hi @YNUL

try this

Copy Excel data with all colors and all format

Hi All, I want to copy data of 1 sheet with color and all the formats and paste it into another sheet of the same excel. it is working with Hot keys but i want another way of doing it. Thanks Charu Rathi

Thanks
Ashwin S