I have several data validation drop-down lists. They are wonderful to automatically populate with a list of rooms. Once a selection is made, the "Space Requirement Data Sheet" VLOOKUPs a host of occupancy and size data for whichever room is specified. It makes creating a series of Space Data Sheets much quicker when I don't have to manually type the room name, let alone re-type all the other data. However, I noticed that if a room name changes or is updated. The change does not filter through. Even though the drop-down list is linked to the original set of room names and the drop-down options themselves update, the previous selection does not update. I believe this is because when you select a drop-down option you are essentially inputting new data, not referencing any other tab or cell. Any thoughts?
Bookmarks