Pivot table in Excel

Question

after googling my specific inquiry online, I haven't found much luck. Basically what I'm trying to do is take a excel file what has lots of columns. Now I'm only interested in some of these columns to be included in a pivot table. Is there a way to automatically create a pivot table, via a script of some sort which will occupy the desired columns in a pivot table that I want to take from the original excel file?

Thank you

Answer 1

The best way to do this for real is to set your file up to make the call to the database and specify that the destination is a pivot table.

How this is done depends greatly on what your data source is. But the functionality to do this is built in to the program without having to use VB at all.