Basically, I need to create a way to take schedule data as a CSV, and make room schedules for individule rooms so they can be viewed and printed. So, I was thinking about writing an excel marco that reads in the CSV file and processes the data within it to create a sheet that will be a room schedule. I'm not really asking for help at this point (yes, this is in fact a school project (for honors I might add)), I'm just asking if this is a feasible way to attack this problem. Suggestions and advice from macro pros would be really appreciated! Thanks!

Yes, you are on the right track. Depending on the latitude you have with the project, if your room schedule layout is going to be mostly static once designed, I';d recommend that you do the layout for one room to your liking and then copy the sheet to make a separate one for each room rather than modifying a single schedule for all the rooms.

Well see, the CSV is from the university database. It's the info on all the classes for the semester. Currently the university has no was to make postable schedules for each room. Thus, this excel macro is supposed to fix that. It's supposed to be able to read in the CSV for the current semester, process it, and spit out a room schedule for a desired room(s). This is something that will be used in future semesters to come. Maybe this is clearer now?

I would use Access for this project. Create a table to import your data. Write a query. Then build a report using the query as your data source. The report can having grouping and page breaks as needed. Also, you can add a prompt to your query to filter certain records.

Yes, well we had hoped to do it in Excel as we figured it would be easier to create the actual schedule. I'm not quite sure how you would generate a schedule using a report. I mean...you could build a textual one. But the schedules we had in mind were like a weekly "calendar". The days across the top and the hours down the side. Then with cells "blocked out" or gray-ed in (whatever you wanna say) to show times when there was a class in the room. This way it would be much easier to read and you can instantly see exactly when the room was not in use. Can you do this with an Access report? I have to have all this coded and ready to go by the end of the semester, so hopefully I can decide on a plan of attack soon.

In that case, use Outlook since it has calendars built in. You may still have to use Excel to get the data in usable form for Outlook.

A better option might be to build your calendar on a form. Either way handling data files is always easier in Access than Excel. You could create a grid using labels or buttons and have the background color change depending on whether or not there is data for the cell. If you really like Excel, you could add a flex grid control to your form or report that is just like a spreadsheet, but that would not be my choice. --Mike