Opening a new sheet from an outside file.

H

HoundofCullin

Hey-o.

How can I get Excel to open up a new sheet from another excel workbook


For example:
I want to right click so that it'll create a new sheet. But instead o
choosing an empty form or a chart I want the new sheet to be one of m
workbooks (I only want one of the sheets) that I had previously create
WITHOUT selecting all and pasting into the new sheet
 
D

Dave Peterson

How about just opening that other workbook and copying the worksheet you want to
this workbook, then closing the "template" workbook?

If you right click on the worksheet tab to be copied, you can select "move or
copy" and plop it into the workbook.
 
Top