I have two work books.

One workbook has 3 sheets, each a different company name.

The 2nd workbook is one sheet only. I have it set up so that the macro
selects a cell (example J5)

This is where I need the help..
The next step I want is to go back to the first workbook, select a specific
sheet, and then lookup the value in the last cell completed in row A and put
it in cell J5 from the 2nd workbook/sheet1.



--
Thanks for your help!

-Danielle