taking data at end of column and sending it to cell in another workbook
 

I have two workbooks. Appendix I and Appendix II. I am trying to tak
the last used cell from column A in Appendix II and sending it to cel
G8 in Appendix I as well as performing a Save As of Appenix I as th
value being sent to G8. Thanks for any help

--
gdeca
-----------------------------------------------------------------------
gdecat's Profile: http://www.excelforum.com/member.php...fo&userid=2430
View this thread: http://www.excelforum.com/showthread.php?threadid=37908

taking data at end of column and sending it to cell in another workbook
 

Hello gdecat,

You say you have 2 workbooks named Appendix I and Appendix II. What ar
the worksheet names the data are on?

Thanks,
Leith Ros

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=37908