How Can I Make a Monthly Pivot Table, with data blocks of Varying Size

[pyromaniac]

I need to create a pivot table of the average mileage that an employee has travelled, the problem is the size of the data block varies, from month to month eg.january is 25 cells with data in from column 'A' to 'L', and february is 100 cells down with data in from column 'A' to 'L'. How can i write a macro that selects only the required data, so as it can be put into a pivot table?

 

[SARUN]

you could pick the Rows & Columns from ActiveSheet.UsedRange "Whereever you go there are people who need you for what you can do..."

 

[SARUN]

Or

Range("A1&quot.Select
Selection.End(xlDown).Select
mLstRow = ActiveCell.Row

ActiveSheet.PivotTableWizard SourceType:=xlDatabase, SourceData:= _
ActiveSheet.Name & "!R1C1:R" & mLstRow & "C26", TableDestination:="", TableName:="PivotTable1"

"C26" as use upto "Z" Column
"Whereever you go there are people who need you for what you can do..."