Hi all,
I'm hoping you are able to help me out. I have two work books, Test1 & Test2, I am using sheetb as the required data. I have inserted text in cell A1 I want to be able to search workbook Test2 sheet1 row 1 for the value in cell A1 test1. the row I am searching in has cells merged, when I find the required criteria I want to be able to copy data below this cell 9 columns and 150 rows, then paste in to test1 sheet2
Thank you in advance for your help.
John
I'm hoping you are able to help me out. I have two work books, Test1 & Test2, I am using sheetb as the required data. I have inserted text in cell A1 I want to be able to search workbook Test2 sheet1 row 1 for the value in cell A1 test1. the row I am searching in has cells merged, when I find the required criteria I want to be able to copy data below this cell 9 columns and 150 rows, then paste in to test1 sheet2
Thank you in advance for your help.
John