| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding Data from Multiple Spreadsheets | Excel Worksheet Functions | |||
| synchronizing data on multiple spreadsheets | Excel Worksheet Functions | |||
| How do I link data between multiple excel spreadsheets | Excel Discussion (Misc queries) | |||
| How do you add multiple spreadsheets in to one spread sheet | Excel Worksheet Functions | |||
| Merge Data from Multiple Spreadsheets | Excel Worksheet Functions | |||
Linear Mode
