Hi Henry,
Do copy and then paste special all

"henry" wrote:

How do I copy and paste from one worksheet to another without loosing the
formulas and formatting