I am trying to transfer a sheet from one workbook to another. When I open
the 2 one (workbook) disappears, is there a way to keep both open?

thanks

If you have 2 workbooks open, only one would have window focus and the
other not. If you right click on the sheet you want to copy, select
the "Move or Copy" option, and look at the workbooks available in the
"To Book" dropdown list, you should be able to find the other workbook
listed if it's open.

Hope that helps

S wrote:
> I am trying to transfer a sheet from one workbook to another. When I open
> the 2 one (workbook) disappears, is there a way to keep both open?
>
> thanks

If you click on Window | Arrange | Horizontal you will then see both
windows on screen, one above the other.

Hope this helps.

Pete

On May 14, 8:25*am, "S" <vir...@blueyonder.co.uk> wrote:
> I am trying to transfer a sheet from one workbook to another. When I open
> the 2 one (workbook) disappears, is there a way to keep both open?
>
> thanks

Thanks got it sorted.


"Pete_UK" <pashurst@auditel.net> wrote in message
news:a39adc1d-0353-45c7-9886-c3574a485906@b64g2000hsa.googlegroups.com...
If you click on Window | Arrange | Horizontal you will then see both
windows on screen, one above the other.

Hope this helps.

Pete

On May 14, 8:25 am, "S" <vir...@blueyonder.co.uk> wrote:
> I am trying to transfer a sheet from one workbook to another. When I open
> the 2 one (workbook) disappears, is there a way to keep both open?
>
> thanks