PDA

View Full Version : VBA code for pivot table



rookie
06-12-2011, 07:29 AM
greetings,

how do i reference fields for a pivot table without actually typing the name of the field in the code?

eg. field names: person_id, sales, outcome

and I want to put the person_id into the values box
sales in the row labels box and
outcome in the column labelss box