T
tklein
I have searched and search but have not been able to find out if this
is possible. I would like to, via VBA, have a single pivot table that
pulls its data from existing pivot tables in seperate workbooks stored
in the same folder.
I understand how to pull in specific cell data from multiple workbooks
but can't seem to find anything that covers P.T.'s
By their very nature, the P.T.'s could be one row deep or many. How to
allow for this programaticaly is troubling.
Each workbook is identical in design so the structure of the P.T.'s
will be the same, except for the number of rows in each.
I appreciate any help that can be given.
PugDuster
is possible. I would like to, via VBA, have a single pivot table that
pulls its data from existing pivot tables in seperate workbooks stored
in the same folder.
I understand how to pull in specific cell data from multiple workbooks
but can't seem to find anything that covers P.T.'s
By their very nature, the P.T.'s could be one row deep or many. How to
allow for this programaticaly is troubling.
Each workbook is identical in design so the structure of the P.T.'s
will be the same, except for the number of rows in each.
I appreciate any help that can be given.
PugDuster