Based on the attached sheet. I have the first column that can be filtered by the number of the room. What I would want to do is print the data. And I would want each filter to print on a different page. So one page would have all the results for Room 1 and a second page for Room 2. etc. My actual data is much longer so I hope to get it a bit more automated rather than filtering by each number then selecting and printing.

Thanks

Excel Forum Print Filter.xlsx