OK, hear me out - I have the following dataset / pivot
example.jpg
Is there a way for me in VBA to list all ages or last names of the people in the current selection?
So, how can I return: "21,27,25,23" or "Betz,Wilde,Smith,Somal" without altering the pivottable or doing lookups to the data table?
It appears that this can be done all with the pivot table. Provide a sample workbook with the data and I can walk you through it.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks