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

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

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