I have a golf score card that shows the hole number with the par and handicap un

Question

I have a golf score card that shows the hole number with the par and handicap under the number. The problem is we don't always start on hole number 1. So what I want to do is have a drop down list with the hole numbers in it 1 thru 18 and when I pick what hole we start on it will auto ffill the scorre card with the reason of the information. Here is my example.

Hole 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

Par 4 4 5 3 4 4 3 5 4 4 5 4 3 4 5 4 3 4

Handicap 11 2 14 9 1 18 16 17 3 15 13 5 10 4 6 12 7 8   

So what I want is when I do the drop down list it will show hole 1 thru 18 and I make the selection so for my example i choose hole 12

Hole   12 13 14 15 16 17 18 1 2 3 4 5 6 7 8 9 10 11

Par 4 3 4 5 4 3 4   4 4 5 3 4 4 3 5 4 4 5

Handicap 5 10 4 6 12 7 8   11 2 14 9 1 18 16 17 3 15 13

So can this bbe done.

Thanks!!!!

Explanation / Answer

Can you create this sample and upload to DropBox or SkyDrive and provide a Link.
The way you have it written down would take me a while to set it up and does it have to be horizontal in instead of vertical? I tried to do it with a data Table containing the information in first set of Numbers but kept coming up with invaild reference so that won't work. Not sure it can be done
In row reference I put sheet with tab name Score:
Row Reference Sheet!A1:A3
Column reference I put Sheet!A2:A19

In either or both receive invalid reference so I assume a Data table that would hole 12 4 and 5 won't show up.

I guess there would have to be three tables and I can't see that that would help any.
I guess one of the Bob's or J.E could figure it out in 2 seconds or less.
Wait until they come along. I'm sure there is a simple way to creeate the list so when you put in Hole 12 4 and 5 would pop up automattically.   

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.