I am trying to earn some brownie points at my work by automating some of the 'simpler' excel reporting tasks. One such report requires me to use 3 different columns to find unique entries from a sheet of date (12000 rows long). A sheet on another table then counts these unique entries.
I have written the following code which works ok but takes around 7 minutes to complete. It takes the same amount of time regardless of disabling automatic calculations.
Can anyone shed any light as to why or offer any suggestion to fix it?
Bookmarks