I would like to have Excel perform the following operation:
Go one by one through the values of range A1:A10, doing the following to each:
Find the cells where the value in the selected cell exists in any of the cells in the range B2:B100
For any cell that has the value anywhere in it, select the row of that cell and copy it to sheet 'Results'
In the end I am looking to copy every row that has the value in any of the cells in A1:A10 as part of the value in the B column cell of that row.
Does anyone have any idea for the code for this? Thanks very much in advance for any help.