i have a pivot chart created from a big database table. is there anyway i can write a macro when i click on the table, it will show the data thats filtered in the table on another sheet?
thanks,
i have a pivot chart created from a big database table. is there anyway i can write a macro when i click on the table, it will show the data thats filtered in the table on another sheet?
thanks,
If you double click on summarised data in the associated pivot table it will extract the data from your table to another sheet automatically.
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)
Bookmarks