I have a spreadsheet that contains a control list of all volunteers on a
given day for a not-for-profit. The first worksheeet has all individuals
listed by area where they are volunteering. I have to provide the leader of
each area with a list of his/her volunteers. The categories are in column
"K." Both the number of volunteers and number of cateogories changes daily. I
would like the macro to provide a separate tab for each category. I found
some code to create separate sheets for each horizontal page break. But that
doesn't help as the number of volunteers per area varies. But if someone
could explain how to clear all existing page breaks and insert them based on
change in category, I can make it work.

Thanks for your help.