Greetings to all!

is there any way to use microsoft excel to efficiently create a class
schedule? The idea is to get information from two tables/spreadsheets
(subjects and
rooms) and merge them to form a new spreadsheet which would follow a certain
number of constraints (no conflicts; each subject goes to the correct type
of room, i.e., laboratory or lecture rooms; room capacity meets the capacity
of the subject; etc.)

Thanks in advance.