how to auto-print if data is on report after each sort?
 

I have a macro that runs on an Excell database that sorts the data according
by the designated "resource" and prints the page. . Certain machine resources
do not have any data associated with them. I would like for the macro to
distinguish between those that have data associated with them and therefore
print page and the ones that don't not to print the page. Machine "resources"
that have data associated with them vary from day to day.
Hopefully, someone has had similiar needs.
Thanks
Steve McFarland