Pivot Table

B

Brent

Is there a command or Vb code to auto create an Excel Pivot Table based on a
query in a database? The database I'm using is not always run in the same
location because of the project it's associated with so I was hoping to be
able to have VBA facilitate the creation of this. Any help would be
greatly appreciated.

Brent
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Pivot Table Dynamically Creating on Query 2
Excel 2013 Pivot Data Range formula reference problem 0
pivot table missing rows? 0
Table Security in Access 2013 1
Connection files and pivot tables 0
SUM & OFFSET & PIVOT TABLE?? 0
How to change Pivot Table external data source (MS Access Database)by VBA 0

Top