Thank you for looking at my problem. I am attaching s spreadsheet which is an excerpt from a much larger workbook for a charity golf tournament.
You will see that Players in the tournament are entered into Column B, and their golf index in Column C. Once Players are entered there, they need to be grouped into foursomes by entering their names in Column K, using a drop down list tied to the "Lists" tab. If a Player should cancel, there is a button to delete their name and index from the Workbook. The button will delete the Player from Columns B and C. My problem is how to also delete their name from Column K.
I have assigned each Player a number in case that is useful in solving this problem. I am a beginner, and have spent hours trying to figure this out. Thank you again.