Try this to get your data
http://www.rondebruin.nl/copy3.htm

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


"Martyn" wrote in message ...
Hi,
I have five workbooks named "data1.xls", "data2.xls",...,"data5.xls".
On each and every Sheet1 from ranges T1:T30 holds data that I want to use on
a seperate workbook.
On a seperate workbook (say named "final.xls") I want to get this data and
calculte the averages like that:

I want to get the values from all closed workbooks "data1.xls", "data2.xls",
"data3.xls", "data4.xls", "data5.xls" Sheet1 T1 values, sum them and devide
by 5 and display that resulting number on "final.xls" Sheet1 T1 cell. Same
operation with data1.xls,data2.xls,data3.xls,data4.xls,data5.xls Sheet1 T2
values, sum them and devide by 5 and display that figure on "final.xls"
Sheet1 T2...etc
How am I solve this?

Thanks in advance
Martyn



---
Outgoing mail is certified Virus Free.
(Giden posta virüssüz olarak belgelendi.)
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.713 / Virus Database: 469 - Release Date: 30.06.2004