VBA Excel - macros for sorting, filtering and removing duplicated records from DB

Hello friends,

I'm dealing with very big files, hundred of thousands of lines Excel files, almost on a daily basis.
Now i need to perform some reports, with data from these files.

Since i'm doing this like a robot, in order to reduce time, i need some help to do a macro to automate this process.
The output of this macro should do some sorting, filtering, counting the total number of records and displaying the most 3 active values, then to reduce these by discarding duplacted values of column A+B:


1. Sort by column A and then by column D (2 criterias)
2. Convert feedback number (Column C) into feedback word
3. Select only records from February 2017
4. Convert date from previous format in Custom format (mmmm dd, yyyy hh:mm:ss AM/PM)
5. Extract Top 3 most active tourists on February 2017 (based on number of total records)
6. Extract Top 3 most visited cities on February 2017 (based on total number of records)
7. Extract Top 3 most visited continents on February 2017 (based on total number of records)
8. Remove all the duplicated records from Columns A & B (E.g.: Alpha - Berlin, to keep only one record)
9. From the newly reduced list, to keep only the records based on selection list from Sheet 2, Column C, discarding all other records that are not on the list (only specific cities).


Thank you in advance

macro is running, to import the data from the DB excel, so the output to be with reduced number of records?

I would probably have a master file with all the macros and running the macro and importing the data I would then save my modified master file as an xlsx file (file saved with all data but without macros) with i new name and then close it.

In this way you keep your original master file intact and you can use it again and again.

The rest of your request I find rather extensive so perhaps you take a look at the forums "Commercial Services" where you can get your problem solved for a fee by the forums best brains.

Alf