Importing data from other files
 

I´m new to Excel so I don´t know if this is really easy to do.

I need to collect data from maybe 1000 different statistic excel files.
They are all similar in structure and looks, but ofcourse they contain
different numbers. Now I need to collect the data from a certain row
and column from the group of files and make some calculation to present
statistic data in a new Excel document. This brings to questions up to
light:

1. How do I do to get the data into the new sheet if it's for example
position G25 in every single source file?

2. Is it possible to "flag" a different position in every source file,
so that they don´t have to be exactly the same when it comes to number
of rows and columns? Maybe try to make Excel get the data from the
position just right of "Total" or something like that. Anyone got some
ideas?

Thanks in advance, and I apologize if this is allready discussed in the
forum.


--
MnO
------------------------------------------------------------------------
MnO's Profile: http://www.excelforum.com/member.php...o&userid=29672
View this thread: http://www.excelforum.com/showthread...hreadid=493812

Importing data from other files
 

Hi MnO

Start here
http://www.rondebruin.nl/copy3.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"MnO" wrote in message ...

I´m new to Excel so I don´t know if this is really easy to do.

I need to collect data from maybe 1000 different statistic excel files.
They are all similar in structure and looks, but ofcourse they contain
different numbers. Now I need to collect the data from a certain row
and column from the group of files and make some calculation to present
statistic data in a new Excel document. This brings to questions up to
light:

1. How do I do to get the data into the new sheet if it's for example
position G25 in every single source file?

2. Is it possible to "flag" a different position in every source file,
so that they don´t have to be exactly the same when it comes to number
of rows and columns? Maybe try to make Excel get the data from the
position just right of "Total" or something like that. Anyone got some
ideas?

Thanks in advance, and I apologize if this is allready discussed in the
forum.


--
MnO
------------------------------------------------------------------------
MnO's Profile: http://www.excelforum.com/member.php...o&userid=29672
View this thread: http://www.excelforum.com/showthread...hreadid=493812

Importing data from other files
 

This formula will link in the value in cell A1 of Sheet 1 of the workbook
named MyTestBook.xls

='D:\[MyTestBook.xls]Sheet1'!A1

hth
Vaya con Dios,
Chuck, CABGx3
"MnO" wrote:


I´m new to Excel so I don´t know if this is really easy to do.

I need to collect data from maybe 1000 different statistic excel files.
They are all similar in structure and looks, but ofcourse they contain
different numbers. Now I need to collect the data from a certain row
and column from the group of files and make some calculation to present
statistic data in a new Excel document. This brings to questions up to
light:

1. How do I do to get the data into the new sheet if it's for example
position G25 in every single source file?

2. Is it possible to "flag" a different position in every source file,
so that they don´t have to be exactly the same when it comes to number
of rows and columns? Maybe try to make Excel get the data from the
position just right of "Total" or something like that. Anyone got some
ideas?

Thanks in advance, and I apologize if this is allready discussed in the
forum.


--
MnO
------------------------------------------------------------------------
MnO's Profile: http://www.excelforum.com/member.php...o&userid=29672
View this thread: http://www.excelforum.com/showthread...hreadid=493812

Importing data from other files
 

Look also here for a formula solution
http://www.rondebruin.nl/summary2.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Ron de Bruin" wrote in message ...
Hi MnO

Start here
http://www.rondebruin.nl/copy3.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"MnO" wrote in message ...

I´m new to Excel so I don´t know if this is really easy to do.

I need to collect data from maybe 1000 different statistic excel files.
They are all similar in structure and looks, but ofcourse they contain
different numbers. Now I need to collect the data from a certain row
and column from the group of files and make some calculation to present
statistic data in a new Excel document. This brings to questions up to
light:

1. How do I do to get the data into the new sheet if it's for example
position G25 in every single source file?

2. Is it possible to "flag" a different position in every source file,
so that they don´t have to be exactly the same when it comes to number
of rows and columns? Maybe try to make Excel get the data from the
position just right of "Total" or something like that. Anyone got some
ideas?

Thanks in advance, and I apologize if this is allready discussed in the
forum.


--
MnO
------------------------------------------------------------------------
MnO's Profile: http://www.excelforum.com/member.php...o&userid=29672
View this thread: http://www.excelforum.com/showthread...hreadid=493812

Importing data from other files
 

Thanks. I´ll try some of that.


--
MnO
------------------------------------------------------------------------
MnO's Profile: http://www.excelforum.com/member.php...o&userid=29672
View this thread: http://www.excelforum.com/showthread...hreadid=493812