ExcelBanter - Deleting rows from two tables

I have two tables both of which contain aprox 2000 rows and 3 columns.
The headings in each column are repectively: tariff level, product
code, product description.

The problem is best illustrated with an example:

Table 1
Tariff Level Product Code Product description
10% 0236 Animal fats
15% 4579 Industrial Chemicals
12% 2093 Tapes

Table 2
Tariff Level Product Code Product Description
13% 1463 Meat
13% 4579 Compact disc's
16% 2967 TV's

I want to move Meat and TV's from table 2 to table 1. The compact disc
entry in table 2 has the same product code as chemicals in table 1,
this is an error, i don't want this row to go into table 1.

Anybody know a quick way of doing this, i have alot of data.

Chris

--
cj21
------------------------------------------------------------------------
cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673
View this thread: http://www.excelforum.com/showthread...hreadid=396848