I only need to select the data in Columns C and D where Column B equals the room number chosen.

So for this example for Rm1, I only need to Select the information in Columns C and D in rows 1 and 2.
If I needed to select Columns C and D for Rm2, I only need to Select the information in Columns C and D in rows 3 and 4.
The macro would almost work like conditional formatting where the data would be highlighted based on a condition in the row.

I hope I explained it better.