Run macros on data spread across multiple spreadsheets
 

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!

Run macros on data spread across multiple spreadsheets
 

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)
--
HTH,
Barb Reinhardt



"akapoor" wrote:

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!

Run macros on data spread across multiple spreadsheets
 

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

"Barb Reinhardt" wrote:

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)
--
HTH,
Barb Reinhardt



"akapoor" wrote:

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!