Hi

I am having trouble with coding a macro to perform a task on two tables. I need to take each of the values in the first column of table 1 in turn and check if this value is anywhere in the first column of table 2. If there is a match then I need to take the whole row where the value is in table 1 and copy it into a third table.

Thanks