Set Up Golf Tee Times in Excel

Set Up Golf Tee Times in Excel

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.

GolfTimes01

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.

GolfTimes02

Book Times Button

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

GolfTimes03

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.

GolfTimes04

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.

GolfTimes05

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.
__________

0 thoughts on “Set Up Golf Tee Times in Excel”

  1. 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.

  2. 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.

  3. Wow, beautiful file… How can i remove those names which shows booked. I dont see any bookmarks against those names?

  4. 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.

    1. @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.

Leave a Reply to Anonymous Cancel reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.