Source Data Display

[Mr.Daines]

Hi,

I am wondering if anyone here knows if there is any way possible to recreate the 'Double Click to Source Data' event on a pivot table.

For instance, I have created a few tables using sumif and countif etc etc, I would like to recreate the 'Double Click to Source Data' event within this table allowing users to get a capture of the data without having to sift through 50,000+ records.

Is this possible?

Thanks in advanced.

 

[oldbrewer]

switch on record macro and do your double click to source data, stop the macro, examine the code

 

[Mr.Daines]

Hi oldbrewer,

Thanks for your reply.

I have already tried that and it only gives this line of code:

Selection.ShowDetail = True

 

[oldbrewer]

Actually I misread your question, sorry.

You are taking raw data and analysing it, and producing a number of "summary tables" for users to peruse.

I suspect that data you are not analysing and reporting is wanted by other users.

Try making a pivot table from the data - this will allow users to cut the data how they like.