Biff, I would be interested in seeing your spreadsheet. I am trying to create
one for the guy here that runs it and I just can't think of a good way.

Thanks

"Biff" wrote:

Hi!

I have a file that I use to run a weekly NFL pick 'em contest.

It sounds just like what you have except I have the "events" (games) listed
on the right and then another column with a drop down to enter the winner.

The players names are listed across the top and in the column under each
players name is another drop down that I use to enter that particular
players picks for that week. I then calculate each players record and
winning percentage for each week.

I do this for each week then I post the results to a website.

If you'd like a copy to see if you can use it for your situation post an
email address and I'll contact you.

Biff

"Blobbies" wrote in message
...
I have a range of data, which is a weekly sports picking competition at
work.

Basically on the left it has the event, and along the top it has my work
colleagues names.

The sports picks are in the range and are in the form of validation lists.

What i would like to do is create an automated summary of who picked what
at
the close of each week, which i can email out to the guys in the
competiton -

i.e: Event 1: New York Mets: persons a, b, c, d and l , Cleveland: e, f,
g,
h, i, j and m

I have 8 events per week, with a number of options per event, thus it is
not
easy or quick to just manually do it!

Any suggestions gratefully received!

Cheers!