With both workbokks open Right-click the sheet tab you want to copy
from and go to Move or Copy. select the correct work book in the To
book: drop field. Make sure the "create copy" check box is ticked.
Once copied you can delete the stuff yo don't need...

On Aug 2, 2:34 pm, clara wrote:
Hi all,

I have to copy a part of a sheet and paste into another workbook's sheet,
how can I paste value and format?

Clara

--
thank you so much for your help