Consolidating Code

[NRZ]

Hello,

I run a NFL pool with a bunch of my friends from a spreadsheet. I use it as a tool to help me learn new tricks and methods in excel (learning is so much more fun when its not what you get paid to do).

Anyway two years ago I started using a Macro for the scoring and I was hoping to simplify the code. Essentially its a matrix and the macro just compares what is populated in the field where they make their pick to a field that is populated with the winner of the game, then makes the appropriate changes. As I was/am new at this I went the brute force method. The core of the code is below:

Please Login or Register  to view this content.

(more of this ad nauseam)

The 'setting' piece repeats 192 times per week (16 games * 12 players) and I have a different macro for each week. As you can imagine this makes for a very long string of code. Due to the repetitive nature I am assuming that there must be another way to do this but Google has failed to provide me much help.

Any help would be greatly appreciated.

Thank you,
Nik

[JBeaucaire]

Maybe something like:

Please Login or Register  to view this content.

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[NRZ]

sorry about that. I have updated the post.

[snb]

Please Login or Register  to view this content.