Hi everyone.
I have been asked to get a pivot table working but am having trouble.
The data array is say A1:V100
A1:V1 is the headers
I have been asked to Create a pivot table using the headers (A1:V1)
and only data in A30:V100.
I can not change any of the source data so inserting a copy A1:V1 in A30:V30 is not an option.
Tried a few options but Pivot tables do not seem to like Multiple ranges.
Any Ideas?
Scott
I have been asked to get a pivot table working but am having trouble.
The data array is say A1:V100
A1:V1 is the headers
I have been asked to Create a pivot table using the headers (A1:V1)
and only data in A30:V100.
I can not change any of the source data so inserting a copy A1:V1 in A30:V30 is not an option.
Tried a few options but Pivot tables do not seem to like Multiple ranges.
Any Ideas?
Scott