Importing and exporting sheets from spreadsheets

R

Roger on Excel

I have a spreadsheet with information stored on Sheets named St1, St2 and St3

The spreadsheet retrieves data from specific cells on the sheets and gathers
them on a summary sheet.

What I would like to do is be able to import St1, St2 and St3 from other
similar spreadsheets so that my spreadsheet can summarize these data sets.

So, I am asking if there is a way to import specific sheets from another
spreadsheet

I would also like to know if there is a way to export changed sheets to save
them as a new workbook? or better still update the spreadsheet from where the
sheets were imported from

Can anyone help
 
B

Bernard Liengme

This is how you refer to a cell in another cell
='[My Second File.xls]Sheet1'!$A$1
best wishes
 

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

Hiding sheets using code 4
hiding sheets using a form 1
Windows 2000 network transfer speed problem 4
joining spreadsheets together for reports and queries? 1
How do you import sheets into an Excel XLA Add-In? 8
Exporting Sheets & Naming new workbook & Breaking links 1
A code to import other xls data into one xls file 3
Create New Workbook and copy sheets from my Speadsheet 4

Top