I tried to set up a macro procedure for printing a pivot table. My
situation is this, I already set up a pivot table with different
location numbers and other pertinent info. I want to print a single
page for each location. As you know , if I do it manually, I have to
select each location from the list one at a time and print each one. I
just want to know if a macro procedure can be done on this operation.
So that I do not have to select any location and Macro will do the
work for me. Thanks.