Excel 2007 : copy data

[djkahc]

Hi Everyone,

I have like 15 workbooks(I call it source) and each work book has 1 column.
How can I copy the average of the 1 column from the source work books into a specific cell of another workbook(I call it a destination).

For example in workbook1 I have column B with 100 numbers, I need to calculate the average and copy this into a cell say C10 of workbook2.

It would be great if anyone can come up with the code.

Thanks
Djkahc
Reply With Quote

[teylyn]

Hi,

in cell C10 of workbook 2, put this formula

=AVERAGE('[workbook1.xls]Sheet1'!$B$1:$B$100)

hth