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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge Multiple workbook sheets into one workbook 0
Start sheet in a workbook 2
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Excel, assign cells in multiple worksheets from one sheet 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Opening a excel file to a specific worksheet. 1
Recalculating when an Excel sheet gets the focus from outside Excel 10
Cannot copy worksheet to another file 2

Back
Top