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

Similar Threads

Need to Keeping Same Display Value on 2 Workbooks 1
find first empty cell in range and copy information from another workbook 19
Comparing cells in workbooks 2
Return Rows from another workbook 7
Copy Sheet1 from Workbook1 to Sheet2 Workbook2 2
cell reference in another workbook 1
Run macro from active workbook whose name keeps changing 20
Copy data from workbook 2 to workbook 3 mystery! 2

Top