You'll only see workbooks that are open in that session.

So open that other workbook first, and you'll be fine.

Autumn Dreams wrote:

Thank you. This will work for new workbooks. However how do I copy it to an
existing workbook. I found this answer on the site, however when I tried it
to copy to an existing workbook, the only option in the dropdown memu was
"new book" and the destination of the original workbook.

"excelent" wrote:

open both workbooks
rightclick on the sheettab u want to copy
select move or copy
checkout the copy box
select destination in dropdown menu
ok

--

Dave Peterson