Trying to Copy from sheet all values to another sheet

Closed
Harvinder - Oct 31, 2015 at 04:19 AM
TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 - Nov 2, 2015 at 11:10 AM
Hello,
I am trying to Copy from sheet's all values to another sheet. But its not coping with their cells formate.

1 reply

TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 523
Nov 2, 2015 at 11:10 AM
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