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