Forum Discussion
Creating a Macro to create a pivot table using a dynamic number of rows
Hi all, So I'm now at the very limit of my abilities ... trying to record and then debug macros - Is there anyone out there that can help? What I'm trying to accomplish is this: 1. Export ...
Were you ever able to solve it? Im facing the exact same problem and its driving me crazy RichTBennett
Have you considered converting the source data to a table and pivoting off the table? All you'd need to update the pivot would be to right-click it and choose refresh. If you really wanted to take it further, you create a macro that simply refreshes the pivot table at intervals.
Another option could be the forthcoming PIVOTBY function...
