Does anyone know how to select a column from a pivot table from a macro? I
would like to select a column that corresponds to an attribute of the
horizontal fields. For example, I would like to specify a year as 2006 then
copy the year no matter which column the data for 2006 is located.