I am in dire need of what I should do to do a sort based on the presence or absence of data. Here's what I am trying to do: I am creating a spreadsheet to randomly assign a list of golfers to foursomes. The list will change from day to day with the number of players ranging from 4 players to 50 players on any given day. I have the spreadsheet pretty much finished except I can't establish a button to do the sort routine. I have the names in column B, no certain number of names each day, beginning in B8, and the RAND() in column C beginning in C8 through C50. I need to know the last filled cell in column B and have the random sort start in the adjacent cell in column C and include column B cells 8 through the last cell with a name in it. It will be the same cell number for both B and C. I would like a button to click that would do this, I hope you understand all this, The way I do it now is to enter the names in column B, highlight the numbers in column C from C8 through the number adjacent to the last name entered. I click on the ascending sort button and it tells me it has detected data in an adjacent field and asks if I want to include it in the sort and I check the box to include it.
Bookmarks