Hi all,
I have a sheet containing tables from multiple projects one beneath the other. I'm using Pivot Tables to automatically summarize the results. However I would like to allow the user to select which projects to add to the summary. That would require complex (discontinuous) ranges.
Is there any way I can do that with VBA?
Any help will be greatly appreciated
Thanks!
Nick
You can't build a pivot table from discontiguous ranges so you would have to copy the data somewhere else, or create a recordset from the data and assign that to the pivot table. (You will have memory leak issues if you need to run it a lot though).
Why not just add all the data to the table then filter the table? It's a lot simpler.
Remember what the dormouse said
Feed your head
That's what I'll have to do. I just wanted to know if there's a lazy way out
Thanks
That is the lazy way. (I consider myself something of an authority on the lazy way of doing things)
I'd agree with you but I'm too lazy
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks