Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
comparison | Excel Worksheet Functions | |||
Text comparison issue in macro...help!!! | Excel Programming | |||
Price Comparison Macro - This Is For An Excel MVP | Excel Discussion (Misc queries) | |||
HELP 2sht comparison MACRO | Excel Discussion (Misc queries) | |||
Macro for a comparison | Excel Programming |