re: Excel tips: How to populate cells after locking other cells

quote:

---

how does that help me with what i want? i don't mean to sound rude, i'm just trying to see what you're getting at.

---

I'm not sure which one of my options you are questioning. I'm a little unsure what your end goal is. I was assuming you wanted 1 page with everyone's picks on them, and that you didn't want to have to enter them on that page.

The way I do our office March Madness, I create the initial bracket, and email that out to everyone. As I get them back, I copy their picks to a new sheet in my main file. I have a sheet that I enter the scores for each game, and then the rankings get updated automatically. March Madness is a lot more complicated than a regular football pickem. I wouldn't be hard for me to set something up if I new what all of the parameters were.