Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing and exporting sheets from spreadsheets
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing and exporting sheets from spreadsheets
This is how you refer to a cell in another cell
='[My Second File.xls]Sheet1'!$A$1 best wishes -- Bernard Liengme http://people.stfx.ca/bliengme Microsoft Excel MVP "Roger on Excel" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exporting & Importing with macros | Excel Programming | |||
Importing and Exporting Data | Excel Discussion (Misc queries) | |||
Exporting/Importing Data | Excel Discussion (Misc queries) | |||
Data Importing and Exporting | Excel Programming | |||
Exporting & Importing Macros | Excel Programming |