I have a spreadsheet with columns from A to AE
The last 12 columns all contain months from the month AFTER the curren
month TO 12 months away.
e.g. nowm, they will show DEC05, JAN06, FEB06 .....etc

The rows contain a numerical value which represents the number of hour
put
The other two columns I am concerned about are C and D - colum
headings ALWAYS stay the same.

I need to create a pivot table automatically that will always use th
cooumn headings from the worksheet (whatever they are)
They'll exist in the same place, but obviously each month the pivo
table is created, the month headings will be different.

how can I do this?
Is it possible to create a pivot and point to a cell reference whe
telling it which columns to use??

thanks in advance..

--
matp
-----------------------------------------------------------------------
matpj's Profile: http://www.excelforum.com/member.php...fo&userid=2107
View this thread: http://www.excelforum.com/showthread.php?threadid=48275