Run macros on data spread across multiple spreadsheets

[Guest]

Hi,

I am working on large chunks of data spread across multiple spreadsheets.
I want to be able to run macros that treat data across these sheets as
contiguous.
eg. the avg() on column A should take into consideration all the values in
column A in all the spreadsheets.

Is this possible ?

Thanks in advance for your help!

 

[Guest]

You don't necessarily need a macro to do this if the worksheets are in the
same workbook. Try something like this:

=AVERAGE(Sheet1:Sheet3!A:A)

 

[Guest]

Thanks for the reply Barb.
I will try this out.

You don't necessarily need a macro to do this if the worksheets are in the
same workbook. Try something like this:

=AVERAGE(Sheet1:Sheet3!A:A)