Set Up Golf Tee Times in Excel

golficon 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 assign groups of players to a selected tee time.

The new version has data validation in column C, which limits the selection to 4 names, and 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.

GolfTimes01

Then, select a start time for the marked names. 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.

GolfTimes02

Finally, click the Book Times button, to add the marked names to the selected time slot.

GolfTimes03

How the 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 criteria range for the advanced filter is range F3:F4.

GolfTimes04

Then, those names are copied, and transposed onto the TeeOffTimes sheet, in the row that matches the selected time.

GolfTimes05

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 (green cells in the screen shot above).

Download the Sample File

To see the golf tee time workbook, and the time booking macro, you can download the Golf Tee Time Excel workbook. The file is in Excel 2003 format, and is zipped. It contains macros, so you'll need to enable macros to test the time booking feature in the sample file.

__________

7 comments to Set Up Golf Tee Times in Excel

  • wayne

    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.

  • Gobish

    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.

  • Peter Heron

    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.

  • Peter Heron

    I'll give the form a try. Thanks so much for the suggestion.

Leave a Reply

  

  

  

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>