Searchinfg for a value in one workbook and copy the entire row to another workbook.
I wish to search for "John L Smith" in sheet 1 column D in workbook Y and, when found, to copy the entire row (values, not formulae) to Workbook Z sheet 1 column A.
Once done to continue to search for a second entry of same value in the same column and to copy to Workbook Z when found and so on until the last found row of data.
Can this be done?
Thanks.
I wish to search for "John L Smith" in sheet 1 column D in workbook Y and, when found, to copy the entire row (values, not formulae) to Workbook Z sheet 1 column A.
Once done to continue to search for a second entry of same value in the same column and to copy to Workbook Z when found and so on until the last found row of data.
Can this be done?
Thanks.