Is there a way to create/automate a Pivot table using VBA. I am trying to sum/display all sales data for all employees by month. The range of the data sheet will have to depend on whatever is in the data sheet since it will constantly be updated. So there could be 10 lines of 100 lines so the pivot table would need to account for all that.
Thanks
Yes its possible. Why dont you attach a sample workbook with the fields you would want to be displayed and we can help you out?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks