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,