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.