Hi all,
So I have three worksheets: 1) Original 2) Source 3) New.
I want to create a macro that loops through a specific range in the Original workbook, searching for each string of characters within each cell of the Original range within a specific cell (say, B2) of each worksheet in the Source workbook. If there is a match, I'd like the macro to copy that worksheet in the Source workbook, and create a new worksheet in the New workbook with the searched character string as the name of the worksheet. Any ideas?
So I have three worksheets: 1) Original 2) Source 3) New.
I want to create a macro that loops through a specific range in the Original workbook, searching for each string of characters within each cell of the Original range within a specific cell (say, B2) of each worksheet in the Source workbook. If there is a match, I'd like the macro to copy that worksheet in the Source workbook, and create a new worksheet in the New workbook with the searched character string as the name of the worksheet. Any ideas?
