See Ron de Bruin's site for collecting from closed workbooks.

http://www.rondebruin.nl/copy7.htm

Or this page at Ron's site.

http://www.rondebruin.nl/ado.htm


Gord Dibben MS Excel MVP

On Mon, 25 May 2009 03:07:02 -0700, Espen Rostad
wrote:

Hi Mike, thank you for the effort

I am afraid your solution wont work for me since source WBs could be opened
by others. I guess the easiest way to solve this would be to put it all in
one WB, but I would like different departments to be able to register data
independent off each others. Can this be done?

Mike H skrev: