There’s a Golf Tee Time Excel workbook on the Contextures site, that I’ve updated, to add a few new features.
You’ll list all the players, then set up golf tee times in Excel.
Improved Version
The new version of the Golf Tee Time file has a few important improvements
- There is data validation in column C, which limits the selection to 4 names
- You can’t mark a name that is already booked.
- The time selector only shows tee times that haven’t been assigned.
Assign Golf Tee Times
On the MemberList sheet, you can enter a list of names in column B.
Mark up to 4 names, by typing an X in column C.
Then, select a start time for the marked names.
Available Times
The drop down list only shows the available times.
In the example below, the 8:20 AM time has been filled, so it’s not in the drop down list.
Book Times Button
Finally, click the Book Times button, to add the marked names to the selected time slot.
How Tee Time Selector Works
When you click the Book Times button, a macro filters the marked names into a hidden column (H) on the MemberList sheet.
The Advanced Filter criteria range for the advanced filter is range F3:F4.
- The Advanced Filter will extract names from the Members column, where there is an x in the Mark column.
Copy and Transpose
After the filter runs, that vertical list of filtered names is copied
Next, the list is transposed into a horizontal list
The horizontal list is pasted onto the TeeOffTimes sheet, in the row that matches the selected time.
Clear the Mark Column
After pasting the names, the Mark column is cleared, so you can select the next group of names.
To start over, clear all the names from the TeeOffTimes sheet (the green cells in the screen shot above).
Download the Sample File
To get the golf tee time workbook, go to the Golf Tee Off Times page on my Contextures site.
The file is in xlsm format, and is zipped. The workbook contains macros, so you’ll need to enable macros if you want to test the time booking feature in the sample file.
__________
How can this be ammended such that you cannot overwrite an existing tee off time? I noticed this does not check to see if the time slot has already been booked. If you accidently select the same time slot again it simply replaces the existing booking without any warning.
The drop down list of times only shows start times that don’t have names booked. You could add a line of code to the macro, to clear out the selected time cell, so the user won’t forget to select a new time from the drop down.
Wow, beautiful file… How can i remove those names which shows booked. I dont see any bookmarks against those names?
@Gobish, clear cells C2:F14 on the TeeOffTimes sheet, when you want to start over.
Hi Debra. This is a great spreadsheet and is similar to something I’m developing so maybe we could work together. My spreadsheet is on Google Drive – I’ll send you the URL if you come back to me.
The big difference though is that I’d like to give members of my golf club access to the shared spreadsheet so they themselves can make the booking. My club has regular weekend members competitions and at the moment you have ot drive up there in person and handwrite your name on a list whcih is very inconvenient In making this an online shared spreadsheet, the biggest obstacle I have (that I can’t resolve), is that I need to add a password to each individual cell that relates to a user name i.e. so if player1 wants to book 0820hrs, then the player has to type in a password at that cell and once the password is accepted, then their name appears in the cell. Sounds easy but as there are 200+ golfers and each has a password, finding a way of doing this is not easy.
Hope you can come back to me please.
@Peter, thanks, and I don’t use Google Sheet too often, but it might be easier to set up a Google Survey form, where people could enter their name, and select a time. All the entries would be time-stamped, so you could see who asked for each time first, if there were duplicate requests.
You can let people see the survey results, so it would show which times were taken. You can also allow people to edit their entries, I think, so they could select a different time later.
Send all the members a link to the online Form, and you wouldn’t need to set up passwords for each person.
I’ll give the form a try. Thanks so much for the suggestion.
Could either of you send me updated information on this?
C. Horn