Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summarizing Data from other spreadsheets
Hello All. I'm looking for a way to summarize data that resides in a number of separate spreadsheets into a table. Lets say there are ten spreadsheets in a directory and I care about data in 4 cells in each of them (i would pre-define the cells, for example, A33,B33,A35,B35). I want to be able run a macro or vb script to generate a table that lists the filename in the first column, data from cell 1 in the next column, data from cell 2 in the next column, etc. Each row would have data from a separate spreadsheet. Any help is appreciated. -mike -- mdahman ------------------------------------------------------------------------ mdahman's Profile: http://www.excelforum.com/member.php...o&userid=24374 View this thread: http://www.excelforum.com/showthread...hreadid=379677 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summarizing Data from other spreadsheets
Hi
Try this example http://www.rondebruin.nl/summary2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "mdahman" wrote in message ... Hello All. I'm looking for a way to summarize data that resides in a number of separate spreadsheets into a table. Lets say there are ten spreadsheets in a directory and I care about data in 4 cells in each of them (i would pre-define the cells, for example, A33,B33,A35,B35). I want to be able run a macro or vb script to generate a table that lists the filename in the first column, data from cell 1 in the next column, data from cell 2 in the next column, etc. Each row would have data from a separate spreadsheet. Any help is appreciated. -mike -- mdahman ------------------------------------------------------------------------ mdahman's Profile: http://www.excelforum.com/member.php...o&userid=24374 View this thread: http://www.excelforum.com/showthread...hreadid=379677 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summarizing Data from other spreadsheets
sweet! thanks! Ron de Bruin Wrote: Hi Try this example http://www.rondebruin.nl/summary2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "mdahman" wrote in message ... Hello All. I'm looking for a way to summarize data that resides in a number of separate spreadsheets into a table. Lets say there are ten spreadsheets in a directory and I care about data in 4 cells in each of them (i would pre-define the cells, for example, A33,B33,A35,B35). I want to be able run a macro or vb script to generate a table that lists the filename in the first column, data from cell 1 in the next column, data from cell 2 in the next column, etc. Each row would have data from a separate spreadsheet. Any help is appreciated. -mike -- mdahman ------------------------------------------------------------------------ mdahman's Profile: http://www.excelforum.com/member.php...o&userid=24374 View this thread: http://www.excelforum.com/showthread...hreadid=379677 -- mdahman ------------------------------------------------------------------------ mdahman's Profile: http://www.excelforum.com/member.php...o&userid=24374 View this thread: http://www.excelforum.com/showthread...hreadid=379677 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summarizing Data | Excel Worksheet Functions | |||
Summarizing Data | Excel Worksheet Functions | |||
Summarizing Data | Excel Worksheet Functions | |||
Summarizing data | Excel Discussion (Misc queries) | |||
Summarizing data | Excel Discussion (Misc queries) |