Hi Dox: I would use a CheckBox - just a thought

"Dox" skrev:

I am creating an Excel worksheet for my hotel that updates the status of
Microwaves and Refridgerators in the rooms. We only have enough for 50% of
the hotel so they move around often. We currently scribble on a piece of
paper which rooms do/do not have micro/fridges. This is tedious, messy, and
unreliable. Does anyone know how I can create a drop-down box so that yes/no
can be specified for each room? I think this would help hotel productivity
as well as increase guest satisfaction.

Thank you in advance for any help that can be given.