Comparison Macro

[seanmartin26]

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

[Tom Ogilvy]

http://www.cpearson.com/excel/duplicat.htm

--
Regards,
Tom Ogilvy


"seanmartin26" wrote:

>
> 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
>
>
> --
> seanmartin26
> ------------------------------------------------------------------------
> seanmartin26's Profile: http://www.excelforum.com/member.php...o&userid=36817
> View this thread: http://www.excelforum.com/showthread...hreadid=565235
>
>

[seanmartin26]

Cheers mate I think this is of help.

Sean