Pivot Table with a moveable end row

[tconnell1965]

Hi

I want to do a pivot table with a range a1:j(variable)

The variable row number is held in M2

I would like to do a pivot with range

'Data Input Used for Pivots'!$A$1:$J$[m2]

How can i do this ?

Thanks

Tony

[Izandol]

You may define a name which refers to:
='Data Input Used for Pivots'!$A$1:INDEX('Data Input Used for Pivots'!$J:$J,m2)
and then use this name as the source for the pivot table (enter =range_name in the source).