Hello Everyone,
I am trying to solve this from a while and couldn't figure it out, so i thought to ask for some help.
This is an excel spreadsheet for a hotel's reservation, with the availability. I would like the cell to show the name of the guest, which is on a different sheet but only if the criteria is met. For example, Booking a room for the date of August 10, 2015 - August 11, 2015, the cell turns red, meaning occupied, which is fine. But I would also the name of the guest in that red cell.
I am attaching the file, any help will be great.
Thanks.
Bookmarks