I have an Excel question that I hope you can help me with. I know in the past
I have seen this done, but can't remember how to do it. When I create a
pivot table and have all the info listed there, how do I get that list to be
on individual sheets? For example, I have a list of VP's with all their cost
centers. I thought there was a way to get all the VP's to be listed on
separate sheets without having to copy the sheets and selecting which VP for
each sheet