I've been trying to find a macro that I could adapt to select rows that contain "No" in col J and Preview / print only those rows, in landscape. Only cols a to J contain data.

Ideally, I'd like rows 2 to 15 to be always included at the top of the print.

So far I've drawn a blank so any help appreciated.