Hi!

I have no idea what the Microsoft NFL Excel schedule in pivot table format
looks like but if it's a pivot table I automatically hate it ! <g

I have a file that does what you want. Want a copy?

It's all setup for the upcoming season.

Biff

"jacob" wrote in message
ups.com...
Hi, I have downloaded the NFL Excel schedule in pivot table format from
Microsoft's website. Here's my query.

I want to extend the table so that you can enter in user's choices as
to who will win each game and then a column (or other method) to select
which team actually won. I'd like to keep a running tally of each
user's correct choices throughout the season.

I can use data validation lists to match winners and losers, but can't
figure out how to copy the validation formatting consecutively down the
columns so that each game is displayed correctly. Perhaps the answer
lies within expanding the pivot table itself, which I know very little
about, unfortunately.

I can email the document in the event someone would like to take poke
at the challenge of helping me set this up...Thank you for your help.

Jacob