Using vba to delete duplicate in different worksheet marco

[th1nkmaster]

Hi all, I currently have a spreadsheet with a bunch of data over 17 different sheets, I need to create a macro to remove duplicate. The data name is 2016 data, 2015 data,2014 data and so on... The hardest parts need to identify different array (c,d,e,f) not the hold dataset to find the duplicate in 17 sheets.
There may be duplicate values between, 2016 data, 2015 data, 2014 data and so on... if there are two versions of the particular car, one of them is removed entirely, leaving just a single version of the car in the dataset. Also, need to inform the user how many cars have been removed in total.

Any help is appreciated

Thanks

 

[th1nkmaster]

And also my data is dynamic. If my data change the result part will change as well is this the reason why the macro can't run?

 

[Fluff]

Judging by the code you supplied in post#3 the macro should only take a couple of seconds.
Do you have any other macros? Especially any Worksheet_Change events?
Also do you have a lot of formulae, or conditional formatting?