Deleting rows from two tables

  • Thread starter Thread starter cj21
  • Start date Start date
C

cj21

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating multiple html tables for products 2
Grand Total for Rows not Working in a Pivot Table 1
How do I create unique pivot tables from the same data 1
How do I consolidate data from several spreadsheets into one. 4
matching data from different sources 2
product info from different data sources 1
Making a table and automating it throughout cells 2
Product descriptions easily made? 1

Back
Top