I currently have 3 different tables on one sheet.
a table that lists the standings of sale execs at a certain site.
another that has the standings of all the sites
a final one that has the standings of all sale execs
as the all sale exec table is bigger than the rest i have an auto filter code...