J
jlogan
I hope I can explain this properly. I use a pivot table in excel and have one of the fields as the one that enables you to select a value to recalculate the table (I don't know what that value is called, but it is the one that appears in the top left corner and you can select the value using a drop down).
Anyhow, on this particular table that I use, there are about 20 values for that field... so 20 different versions of the pivot table depending on which value is chosen.
I would like to output all 20 versions of the table at once (onto separate worksheets would be ideal) so that I could send the results of all 20 versions in one spreadsheet to any interested parties.
I hope this makes sense. Any help at all in making this a reality would be greatly appreciated.
Thank you in advance!!!!!!
Anyhow, on this particular table that I use, there are about 20 values for that field... so 20 different versions of the pivot table depending on which value is chosen.
I would like to output all 20 versions of the table at once (onto separate worksheets would be ideal) so that I could send the results of all 20 versions in one spreadsheet to any interested parties.
I hope this makes sense. Any help at all in making this a reality would be greatly appreciated.
Thank you in advance!!!!!!