Thanks Ron

You helped me with the same problem a couple of years ago but I had lost all
the data - new computer etc etc

Thanks again

"Ron de Bruin" wrote:

Try
http://www.rondebruin.nl/merge.htm

If you want to use code see my site for examples

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"cgy" wrote in message ...
I have approx 300 spreadsheets that contain data that I want to get into a
single spreadsheet. The data is in the same cell in every one but I cannot
find a way to copy it into a new spreadsheet quickly