Delete duplicate rows without deleting entire row

[Chulius Caesar]

I have a sheet which downloads a table of data using query table into
"raw data" sheet for then copying into a master sheet. The master shee
has the format below. There are a number of tables with different data
The raw data sheet will hold only queried data for a specific table dat
se

Master sheet
_____A ______B___________________F_________
1____Date____Price_______________Person____Sale
2____ ... _____ .... _______________ ... ______ ...

Basically I need a macro to copy the data from the "Raw data" sheet an
append to the end of the table in the "master data" sheet.

I then need to delete duplicate data as there will duplicates fro
previous queries. That way only new data will be added to the table
sheet

However, I need to delete duplicates without deleting the entire row a
there will be other tables on the master sheet (as above: Table 1 i
data/price and Table 2 is person/sales).

All other solutions I have read involve deleting the entire row which i
no good since there are other items which would be deleted by this

Thank

 

[Don Guillett]

I have a sheet which downloads a table of data using query table into a
"raw data" sheet for then copying into a master sheet. The master sheet
has the format below. There are a number of tables with different data.
The raw data sheet will hold only queried data for a specific table data
set

Master sheet:
_____A ______B___________________F_________G
1____Date____Price_______________Person____Sales
2____ ... _____ .... _______________ ... ______ ....

Basically I need a macro to copy the data from the "Raw data" sheet and
append to the end of the table in the "master data" sheet.

I then need to delete duplicate data as there will duplicates from
previous queries. That way only new data will be added to the table /
sheet.

However, I need to delete duplicates without deleting the entire row as
there will be other tables on the master sheet (as above: Table 1 is
data/price and Table 2 is person/sales).

All other solutions I have read involve deleting the entire row which is
no good since there are other items which would be deleted by this.

Thanks

If desired, send your file with explanation and excel version to ME.