Pivot table with multiple Array

[scotttt]

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

 

[Titian]

insert a new column and tag each row with either "I" to include or "E" to exclude.

Place the new row heading into the Pivot Table Page field and select "I". You will get the data you require.

 

[scotttt]

I thougt abount that but I cant change the source data which unfortinately includes rows and collumns.

S