I created a spread sheet which acts as a rooming list. Columns have names,
in date out date and room type designated by a letter (theres are 4 types).
I'm going crazy trying to set a format which will automatically prepopulate
the room type code associated with a name and the dates into individual
columns (each one for a date within the span of the time people will be in
the hotel). At the bottom of each date column I have a total (which is
segmented into the various room types so that I can have a daily total sum
for each room type.