Copy & Paste Unique Values

I have several Excel files that are in the same format, but with unique data. I would like to upload the data to a central file once a month. I have created the below macro in each of the files to append the data to the central "master" file. It works well, but I would like to add code so that it will not duplicate data, but replace it with the latest values if the file had already been submitted. In the individual files, each row of data has a unique value in column A. It would be ideal if the macro would replace the line item in the central "master" file if the unique value was already present. Does anyone have any ideas on how to modify my macro code to do this?

Please Login or Register  to view this content.

Under the data ribbon, there is an icon Called "Remove Duplicates"
Experiment with it.
You could use it after all the data has been transferred to the sheet.
Once you have it figured out, use your macro recorder to get the code.