- 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/19/14 at 4:22 pm to LSUtigerME
Posted on 9/19/14 at 4:22 pm to LSUtigerME
quote:
You could possibly also build it in an access database. This would have similar coding, but eliminate the opening/saving issue. Their picks would be recorded to a master list that only showed after selecting/locking all their picks.
after thinking it over, i think i like this idea better. Now, i know it's probably too late for this year, so i figured i'd get a jump on it for next season.
I hate to ask, but can you give me some tips on how to get started? i haven't used access in years.
Posted on 9/19/14 at 5:06 pm to finchmeister08
Download a template that comes close then customize.
Posted on 9/19/14 at 6:10 pm to finchmeister08
Honestly, I'm not a big fan of Access unless you have an extremely large amount of data/tables you're trying to link. For small data collection, I'm more in favor of using the forms within excel. They can function very similar to some Access functions.
The template in Access will probably the best place to start rather than going from a blank slate.
How complex do you want it to be? What did you have in mind?
I think this could be done simply and neatly in Excel (plus it's what I know much better). If I knew what you had in mind for the overall look/functionality, I could point you in the right direction.
The template in Access will probably the best place to start rather than going from a blank slate.
How complex do you want it to be? What did you have in mind?
I think this could be done simply and neatly in Excel (plus it's what I know much better). If I knew what you had in mind for the overall look/functionality, I could point you in the right direction.
Popular
Back to top
Follow TigerDroppings for LSU Football News