Depending on the source database I think I might rotate the table before
bringing it into excel.

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"matt4003" wrote:
|
| Hello,
|
| I am looking for some help to create a Pivot table with VBA. Basically
| I have a set of Forecasts to download out of a database and it always
| comes in the same format, however, the information, months, etc.
| change. I need a pivot table generated that can tell how many rows and
| columns are there plus adapt to the different headers....any
| sugestions?? I really want this pivot table to be generated when I run
| my formating macro.
|
| Thanks,
| Matt
|
|
| --
| matt4003
| ------------------------------------------------------------------------
| matt4003's Profile:
http://www.excelforum.com/member.php...fo&userid=9635
| View this thread: http://www.excelforum.com/showthread...hreadid=561900
|