Pivot Table - Looping Through Pivot Fields

Hey Guy and Dolls,

It’s my first time here, so bear with me if I haven't done something I was suppose to do while posting. Any feedback would be greatly appreciated.

First off, I would like to thank the person/people who created this site so people like me can ask questions. Also I would like to thank the volunteers that use their spare time (or sometimes work time ) to answer my questions. I hope that in the future I will be among these warriors of people.

Ok my question, it’s in regards to pivot table pivot fields.

I have created a macro that will create a pivot table in a specified worksheet and fill in the row and data fields. The problem is I need the data field to include multiple pivot fields that meet a specified criteria.

Is it possible the macro could loop through all available pivot fields, looking for the word 'Points' and then putting the matching pivot field into the data field?

To explain in more detail I have attached a sample workbook with my existing macro and the following worksheets:

1. Data - Contains the data that the pivot table uses. This is generic.
2. Pivot - This is where the macro creates the pivot table. This is generic.
3. CorrectPivot - This shows a pivot table in which I would like the macro to create.

I hope I was as clear as possible.

Kind Regards

Mini12