Excel pivot tables question...?

Question

okay, i've been trying to resolve this issue for quite some time now, and its not helping that i think im picking up carpal tunnel syndrome so the more i try to do this the worse the pain gets...so PLEASEEEEE help lol

basically, i got the general idea of pivot tables, very nice way to organize everything...i got info from a database/sql server query and now its all organized...well now i need to extract information from the pivot tables into other sheets of the workbook...how can i do that? i want to say basically say, if this certain cell matches with the column in the pivot table, then return all the matches into this other cell...if that makes any sense at all...when i double click on the pivot table it returns the info amazingly and the way i want it, i just want it to do that automatically by referencing to a cell in another sheet and returning all the info into another cell...i have no clue how to describe this...d**n it...if u know what i mean, please help...thank you

Answer 1

record a macro of you checking if this certain cell matches with the column in the pivot table and you clicking on the match which causes it to return what you want, then save the information in the new view to a new sheet with

Now()& "_Data" as the sheets name. Then stop recording the macro, name it 'PivotTableDataExtraction' or whatever you want.

Then run the macro to see what comes up and if it is not what you want edit the macro until it does.