formatting change after pasting into a new weoksheet

[Edward]

Hi everybody,
When I copy a worksheet to another one cell background colors change and
also I lose the formatting ? any suggestions what might cause this?

 

[trip_to_tokyo]

Keep both windows open at the same time when you copy and paste and I think
that will obviate the problem.

Please hit Yes if my comments have helped.

Thanks.