Delete duplicate rows without deleting entire row

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

On Saturday, July 7, 2012 3:20:26 AM UTC-5, Chulius Caesar wrote:
> 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
>
>
>
>
> --
> Chulius Caesar

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