Dear all
I am working on a rooming list where we have to indicate the single room, twinbed room, doublebed room
Single Room - 1 guest
twin bed room - 1 or 2 guests, separated bed
double bed - 1 or 2 guests, one king bed
I have all the guests names and assigned to different room type.
I have to merge the cell for the room to indicate that they are assigned in same room
Issues are when i want to
a) count the rooms, sometime it does not work for merged cell
b)sort the arrival date, it does not work
See attached a sample.
How can i solve it
appreciated your help in advance
Eric
i
Bookmarks