Hi,
I have a table that is about columns by up to 65k rows.
I have a pivot table based on this giant table.

I am looking for a quick way to get summary data if I'm searching up to 15
specific columns out of a possible 30....
The 30 are the total possible columns I may want to search but I would only
need to search a max of 15 columns for any given operation. The problem is
that those 15 could be different each time.

I currently use macros to change autofilters have a Subtotal(109,...)
formula and get that value but this is very slow.

I was wondering if there is a way to extract this data using something like
Get Pivot Data....

Again the difficulty is that I may need to filter on up to 15 columns at a
time but those 15 columns might be different each time.
My understanding of Pivot Tables is that you have to pre-build a pivot and
then look for data in the pre-exisiting table. This wouldn't work for me
because I can't have a pivot with 30 column fields open.

If this doesn't make sense, please let me know.
Thanks for any help,
MikeZz