Currently the macro preps the data by inserting a column and inputting several formulas. I've not ran it yet in this example
I need it to remove any rows with 0.00 in column T, I assume the fastest and best way would be to use filter?
I then need it to remove any rows that have any of the following combinations in column I and J:
Bond 8 and Sec 3
Bond 17 and Sec 5
Bond 8 and Sec 8
Bond 12 and Sec 1
After these have been removed I need to sort them from highest to lowest for column T but they must be kept in location groups (all London's grouped, all Brighton's grouped.. etc
After doing that I need to make pie charts for the top ten for each location from the data In column T
Currently the macro looks like:
Any help would be much appreciated.