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 gathering values from multiple workbooks

Oops

Here is the link
http://www.rondebruin.nl/merge.htm



--

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


"Rotata" wrote in message ...
Help! My boss wants some stats. In order to get her what she needs, I will
have to open several hundred password protected workbooks (each workbook has
five pages), copy a column from worksheet 4, and paste the values to a new
workbook. I tried using Access to gather the data, but it just laughed at me.

Any suggestions on how to make the work go faster?

WinXP, Office 2003.

Thanks!
-----