Opening a new sheet from an outside file.

  • Thread starter Thread starter HoundofCullin
  • Start date Start date
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
 
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.
 
Back
Top