The filter will not work in my case because the data I have will change all the time (sometimes it will be a lot and sometimes it may be only few names).
The excel user will export the data from an online website to excel (12 months data).
My question: is there any VBA code that will "automatically" create a new table showing only the unique names (compering in the 12 months data) and put it separate by months?
Able Target Limited
Denline Uniforms, inf
Electron Microscopy Sciences
Jun (will not even appear because no unique names
This need to be dynamic, because all the export data will be different.
This new table need to be paste in the same sheet under the name "New Beneficiaries in which month" (range ("J9")