On Jul 15, 8:33*pm, "Bernard Liengme"
wrote:
Open both workbooks (make sure you have backups in case something goes
wrong)
Use Window | Arrange | Tiled *so you can see both
Hold down the CTRL key and drag the tab of the source worksheet to the tab
line of the target book; Release mouse button
Now the second book has an exact copy of the sheet from the first book
best wishes
--
Bernard Liengme
Microsoft Excel MVPhttp://people.stfx.ca/bliengme

"robzrob" wrote in message

...



I've got a worksheet in one workbook that I want to paste into a blank
worksheet in another. *I've tried selecting the whole worksheet, then
Copy, etc, tried selecting only the particular cells I want, then
Copy, etc, I've tried Paste, Paste Special, All, Formats, Formulas,
the lot. *But it still won't paste all the formulas nor all the
formats in, only some, as far as I can see. *I've got both worksheets
open in the 'same' Excel, ie I haven't got Excel open twice (it won't
do it at all then). *Any answers?- Hide quoted text -

- Show quoted text -

Hello Bernard

Thank you very much - I was giving up hope!