MPDenver
asked on
Excel Voting
I would like to create a macro that reads and writes to the legends votes tab.
Voting 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.
Example
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
etc..
etc..
At the end I should be able to determine the top priorities based on votes.
Voting.xlsx
Voting 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.
Example
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
etc..
etc..
At the end I should be able to determine the top priorities based on votes.
Voting.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Glad it works. If you want an email function, however, may I respectfully suggest you ask a second question specifying what you need, rather than tack an entirely different question onto your first one?
ASKER
Great Work
ASKER