Thread: get data from multiple spreadsheets into another
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default get data from multiple spreadsheets into another
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
Reply With QuoteReply With Quote