Hi All,

Would anyone be able to help a poor sap such as myself?
I have data on Sheet1 and pivot table on Sheet2.
I would like a Macro to automatically drag the fields (in this case the Columns) from Sheet1 into the fields/box.
Basically Cell A1 from Sheet1 to the Row labels field box, then and Cells B1, C1, D1... etc in the Values field box.

BUT, the columns in Sheet1 will constantly increase and change.

is this possible?

Regards,