I have a sheet that has "NR" or Buy" in colomn A. I want an input box to open and tell the user the total number of "buy" found and aski if they want to print a report. If they choose yes to print then the macro will sort by colomn B and print all the rows that contain "Buy"

Please let me know if this is even possible.

Thanks
-James