Excel has three worksheets, the first is the name and number, the second is the room number and area, and the third is the printed page, which has passed the function.

Hello: I need vba, but I can't. I think we can put it another way, that is, after entering the name number in Table 2, the color change of this bank indicates that it has been selected. The table 1 can also be called a cell: conditional formatting and realizing this function. Don't worry about multiple choices in one room.

If you are worried that one person can select multiple times, you can set the data validity in Table 2. If one person passes, it will prompt an error if you enter again.

It was very clean, but do you know who chose which room? Or my method can record the process.