Auto Print Filters but stop before (BLANKS)

[LindsPow]

Hi There,

I want to create a Macro that will select each filter in a specified column and then auto print. The info on this sheet changes every time I open it and multiple people will be using the file and I want to be able create a button and assign the Macro. I want the filter column to be column C. I have a formula in all the cells in Column C already that appear blank if no data is found on another sheet and I don't want to print the (BLANKS) filter. Any help would be greatly appreciated!