Populate a defined number of blank cells in a column with "yes"

**goleafsgo** · 05-16-2020, 04:59 PM

I'm making a board game in Excel where there are two players. Each player is allocated 6 cards that they may potentially draw from, but do not necessarily have to reveal all.
Cards not revealed will be first in line for the next round. Cards that have been revealed/used are taken out of the game.
helpmepls.PNG
In the example here, cells D2:D4 and D8:D10 represent cards revealed in the past round.
For this round, the first 6 cards with empty values in the used? column should be allocated to player1. The next 6 cards with empty values in used? should be allocated to player 2. These values are represented in the table in column K:M

I have already written the code to generate the 12 values in the table in column K:M as the first 12 cards in the list that have not been used. I am now stuck on the step before this: Let's say in the current round, player1 reveals 3 cards and player2 reveals 2 cards. I have a cell for each player that, at the end of each round, displays the number of cards they drew.This means that the first three cards in the table should be marked as used by player 1. The next three cards (for player 1, cards 4 to 6) are not marked and used for next round. The following 2 cards (for player 2, card 7 and 8) should also be marked. The marking process of entering "yes" into the used? column should be based on the aformentioned two cells that count the # of cards used by each player. Again, the population of player 2 cards should start from the 7th card that hasn't already been used.

I would really appreciate any help and I know this many not be super clear; please let me know if I can clarify further. Thanks in advance!

**JLGWhiz** · 05-16-2020, 07:13 PM

You do no describe what a player does to "use" or "reveal" a card. I suspect you could use that event to populate the cell related to the used or revealed value.