Hi-All,

Newbie here----

Is there a way to open multiple tabs of information in a pivot table at the
same time, do a select all, and then select a print area or am I going about
this the wrong way.

I have a pivot table that I am working with and when you click on certain
cells it displays additional sheets of information i.e. name, address,
phone, etc..., but I only need parts of the individual sheets(name & phone
numbers). There must be 500 cells on the pivot table that have to be opened
to obtain the information I need, so you can see how time consuming it could
get to try to click on one cell at a time and either do a cut,copy,paste to
new sheets or do a set print area on each sheet that I open.

Thanks for your help in advance.

Britt