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