Your solution is he
http://www.rondebruin.nl/copy1.htm

Other VERY useful resources:
http://www.rondebruin.nl/ado.htm
http://www.rondebruin.nl/copy7.htm


Good luck,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Jomiop" wrote:

I need to copy from cell A9 all cells with data, (the end row varies from day
to day) from workbook1, and place the information on to a sheet called data
in workbook 2. I would like to run this macro from workbook2 and the user
not see workbook1