Sorting Data into two different Sets

I am trying to add a sort to a macro that would separate the data into two different groups. There are columns for date, room, time. I would like to separate into a group the includes rooms A,B,C that is sorted by date, room, time then a group that includes rooms D,E,F that is also sorted by date, room, time.