Trying to Copy from sheet all values to another sheet

Closed
Report
-
Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
-
Hello,
I am trying to Copy from sheet's all values to another sheet. But its not coping with their cells formate.

1 reply

Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
491
Hi Harvinder,

Did you use a pastespecial > Values?

Then format isn't copied over.

You could a use "normal" paste first for the format and then use pastespecial > values for the values.

or vice versa.

Best regards,
Trowa
0