Prev: user form
Next: Saving tick data
From: Roger on Excel on 17 Dec 2009 13:54
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
From: Bernard Liengme on 17 Dec 2009 14:08
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" <RogeronExcel(a)discussions.microsoft.com> wrote in message
news:D83F647A-0DDE-4901-9462-7CA8D5E64365(a)microsoft.com...
> 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

 | 
Pages: 1
Prev: user form
Next: Saving tick data