I would like to create a macro that reads and writes to the legends votes tab.
1. Populates priorities from legends votes tab one at a time.
2. When user clicks submit vote the record is counted and saved back to the "legends votes tab" under the corresponding row in the votes column as one vote. The next two records are compared for voting until no more comparisons are left.
Legend Votes Tab lists all priorities.
Every Priority needs to be voted against each priority.
1 vs 2 all the way to 16
2 vs 3 all the way to 16
3 vs 4 all the way to 16
At the end I should be able to determine the top priorities based on votes.