OK people...I am garbage at VBA. I hope someone better versed could bang this out pretty quickly.

I am setting up a workbook for a Derby pool. People will probably be arriving late and getting all their names into the pool by post time will be a challenge so I'd like to automate it as much as possible.

The way I see it now is the routine begins by asking what the person's initial are and how many squares they want. That much I think I can do. :-)

At this point, I would like the routine to find a random cell in the table, check if it's empty, if not then search again, if it is then enter Player. Repeat for number of Squares.

Currently, the table (DerbyField) is 20 rows (each Derby entrant) by 4 pool columns (Win, Place, Show, and Last). Columns won't change but there may be last minute scratches to the field so some rows may be deleted.



The random search is important. Obviously, I don't want people grabbing all the squares for the favorite or for the Win column.

Anyone care to take a stab at this?

Attached Files

Derby pool.xlsm (20.3 KB, 17 views)