Importing spreadsheets from another Excel file

[AlexSlivi]

I used Access to produce an .xls file (call it June2011.xls) with three sheets in it (call these NoFunds, Formatted, and FundNames). I need to create a module in Excel that creates more sheets (pivot tables, summaries, etc.) that read from the Formatted sheet as well as format the data so it's easier to read.

The way I see doing this, unless someone has a different solution (such as something I should do in Access), is to create another Excel file that's code imports June2011.xls and then continues to manipulate the spreadsheets for the desired results.

So how does one Excel file import sheets from another Excel file?

Thanks,
Alex

 

[Andrew Poulsom]

Welcome to MrExcel.

You can move worksheets between workbooks (right click the sheet tab and choose Move or Copy...).

 

[AlexSlivi]

Thank you. And thanks for the welcome--I've been reading on here for a couple weeks, but I keep finding the answers I need so there's no need to ever post!

So I would still have to open the June2011.xls document and move the spreadsheets to the other .xls document each time I needed to do this?

 

[Andrew Poulsom]

So I would still have to open the June2011.xls document and move the spreadsheets to the other .xls document each time I needed to do this?

Yes (or copy them).