Comparison Macro
 

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

Comparison Macro
 

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

Comparison Macro
 

Cheers mate I think this is of help.

Sean


--
seanmartin26
------------------------------------------------------------------------
seanmartin26's Profile: http://www.excelforum.com/member.php...o&userid=36817
View this thread: http://www.excelforum.com/showthread...hreadid=565235