Excel Pivot Table Macro

[TGillingham]

Hi All,

This is my first post so go easy on me!

I have a selection of data which is being pulled out of a database into an excel spreadsheet.

I have set-up a recording of the macro (see below), but it is not pulling out any of the collum fields.

The row's pull out and set-up perfect every time, but the collum just produces one called "count".


Current code I am using:

Please Login or Register  to view this content.

If this isn't enough information let me know, I hope someone can help.

Thanks Tom

[TGillingham]

Anyone got even an idea?

Thanks again

Tom

[JosephP]

just need to set the column field after the data field

Please Login or Register  to view this content.