Links in Excel

T

terabar

I have 2 tables - Details & Summary. The Summary table basicall
provides a count of data in the Details based on some criteria. Is i
possible to just click on a count in the Summary table that woul
automatically show the corresponding records on the Details table
 
B

Bernie Deitrick

terabar,

If you used a Pivot Table as your summary table, then you would be able to
double click and see details.

HTH,
Bernie
MS Excel MVP
 
T

terabar

Wow.. that is cool!! I would presume that Microsoft has automated the
Advance Filter function to produce those Details on a double click
event.

OK, this may sound uncool but my summary is done manually using array
formulae due to multiple conditions
{=SUM((condition1)*(condition2)...)}. Is it possible to produce the
same effect by automating the advance filter and so produce a new
worksheet? I would presume this is using some really complicated
VBA...

Any chance of the source code for this event... if possible??
 
Top