I have a table of data for room schedules. However, a bunch of the fields are combined (such as weekday, month day, and start & end times).
So, I paste the raw data into one worksheet. On a second worksheet, I use formulas to pull from that data so that each column has only one piece of data (weekday, start time, end time, room name).
So, why I’m trying to do is first sort everything in that second worksheet automatically according to levels. First by room, then weekday, then by start time.
Once sorted, I have another worksheet with a drop down data validation list of rooms. The idea was to use a VLOOKUP to pull the schedule data, and display it in a table format where the weekdays are in columns, and the schedule data is displayed in cells below in order of start time using CONTACT to combine the data for display. And then print it.
Ideally, all someone would have to do is paste the raw schedule data, then go to the display worksheet, select the room name, and print the sheet.
Now, I sort of been able to put bits & pieces of this together, but haven’t managed to get something to flow from start to finish—I think I’m missing a few steps.
The main problem I’m encountering, how to get the formatted data into a sorted state that I then can use VLOOKUP to retrieve.
Could anyone point me in the right direction?
Thanks
Bookmarks