Alright, so I'm using a pivot table to count the unique state I have in a column. Pivot table works perfect except for a couple of things.
1. Can I use VBA to automatically program the pivot table?
1a. If so, how?
1b. Reason being, the table is supposed to me each month as a brand new file. If I could use VBA, I could click a macro button and it creates it automatically, along with some other handy features.
Any ideas?
Hi Muhnamana,
I'd suggest recording a macro whilst creating a pivot table from your data. You can then review the code created in the VB Editor (ALT+F11) to see how it is done via code. (Although the macro recorder doesn't always record efficient code, it shows you the basic building blocks well enough.)
Once you have that, ask some specific questions regarding the code that you don't understand or might need to change from time to time.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks