Macro to automatically autofilter and print sheet

@ravishankar

Thanks for the tip, this worked a treat. How would I go about matching a AutoFilter dependent on a value in a droplist in cell C2?

Thanks again.