I'm hoping someone may be able to help me. I would like to complete a macro that will allow information from workbook 1 to copy into workbook 2. But only for the row in which cell A is selected in work book 1. So if I move from cell A200 to cell A14 in book one then the information in cell A14 will copy into book 2.