BJBALENTINE
New Member
- Joined
- Oct 10, 2014
- Messages
- 1
I'm a youth baseball coach and I'm trying to make creating my lineup or player positions easier. What I want to do is this:
I have a small table set up for each position (LF, CF, RF, 1B, 2B etc). At each of these I have the table set up with 6 blank rows.
Off to the side I have 6 columns labled 1 thru 6. In each of these I have my players first name listed (12 players).
When making a position rotation, the frustrating part is as you go, unless you're marking the names off of a list you lose track of who you already put down and who you haven't put down yet. This is exactly what I'm trying to do. I want to be able to type in "Chris" in the first slot (first inning) at catcher and Chris' name automatically highlights yellow under the "1" column to the right. Thus indicating that for the first inning, Chris has already been placed and then I can move on to the next one.
I'm pretty good with Excel and I've been trying all kinds of ways to do this, but can't make it work.
Help!!
If it's possible I can send you what I have now, so you can see exactly where I am.
Thanks
BJ
I have a small table set up for each position (LF, CF, RF, 1B, 2B etc). At each of these I have the table set up with 6 blank rows.
Off to the side I have 6 columns labled 1 thru 6. In each of these I have my players first name listed (12 players).
When making a position rotation, the frustrating part is as you go, unless you're marking the names off of a list you lose track of who you already put down and who you haven't put down yet. This is exactly what I'm trying to do. I want to be able to type in "Chris" in the first slot (first inning) at catcher and Chris' name automatically highlights yellow under the "1" column to the right. Thus indicating that for the first inning, Chris has already been placed and then I can move on to the next one.
I'm pretty good with Excel and I've been trying all kinds of ways to do this, but can't make it work.
Help!!
If it's possible I can send you what I have now, so you can see exactly where I am.
Thanks
BJ