copy range using last active cell reference from 1 wkb to another

J

Jomiop

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top