- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
re: Excel tips: How to populate cells after locking other cells
Posted on 9/17/14 at 1:15 pm to finchmeister08
Posted on 9/17/14 at 1:15 pm to finchmeister08
The simplest thing would be to have a summary tab that references everyone's picks. When each person sends you their picks, "move" them to the master file, and rename the tab "Entry #". Then you can use the indirect command to reference the sheet name and cell #. This is how I do our March Madness at work.
Posted on 9/17/14 at 1:18 pm to CubsFanBudMan
Another option would be to create a Google Docs Form. It would provide a spreadsheet with all of the submissions.
Popular
Back to top
Follow TigerDroppings for LSU Football News