With my existing testcode I lookup data in a PivotTable by referring to a fixed position. 

Please Login or Register  to view this content.
After testing this result he should lookup data in Pivot Tables by criteria eg. Give me the Total (Sum) where the columnName is equal to 01/2007 and the Row Value is 100. Can someone give a good idea on how I need to look up along variabel criteria in a PivotTable. FYI the user enters a date in a UserForm. This parameter will retrieve the data.