Gathering data
 

Another challenge,

Probably biting off more then I can chew but what the
heck..

I have over a hundred excel files with data in maybe
twenty cells on each "sheet1"

I would like to gather that data into one master
spreadsheet. Any suggestions?

I know I can just "link" the cells to the master
spreadsheet but I was looking for a better way to do this?

I know there are few details her but if someone is
interested in discussing this I would be happy to share
more details of what I am trying to accomplish.

Kelly

Gathering data
 

Try the example on my tips page
http://www.rondebruin.nl/tips.htm

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Kelly" wrote in message ...
Another challenge,

Probably biting off more then I can chew but what the
heck..

I have over a hundred excel files with data in maybe
twenty cells on each "sheet1"

I would like to gather that data into one master
spreadsheet. Any suggestions?

I know I can just "link" the cells to the master
spreadsheet but I was looking for a better way to do this?

I know there are few details her but if someone is
interested in discussing this I would be happy to share
more details of what I am trying to accomplish.

Kelly