IMPLEMENT > SAVE AS < ON A WORKSHEET AND SAVE IT IN ANOTHER WORKBOOK.

[roameri]

Is it possible to ONLY select a Worksheet "A" in a Workbook "I" for >
SAVE AS < as a Worksheet "B" in another Workbook "II"?
I understand that both > SAVE < and > SAVE AS < apply to a Workbook and
not a particular Worksheet in a Workbook.
However, a right click on the Worksheet "A" tab gives the option of
copying it to a "NEW BOOK". Can that option ever be the file name of
Workbook "II" ? The latter does not come in the Highlight.
Cheers!!!
Jamshed.

 

[MaChii]

You need to open both Workbooks in order to copy worksheet from one to
another.

MaChii

 

[Dave Peterson]

There's a dropdown list in the "Move or Copy" dialog.

If workbook II is open, you'll see it in the "to book" dropdown (use that arrow
to show all the open workbooks plus (new workbook).

If workbook II doesn't exist, you can copy the worksheet to a new workbook and
then save that new workbook as workbook II.

 

[roameri]

Thanks Dave & MaChii,
Cheers!!!
Jamshed.