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