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


--
terabar
------------------------------------------------------------------------
terabar's Profile: http://www.excelforum.com/member.php...o&userid=24272
View this thread: http://www.excelforum.com/showthread...hreadid=378875

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


"terabar" wrote in
message ...

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


--
terabar
------------------------------------------------------------------------
terabar's Profile:
http://www.excelforum.com/member.php...o&userid=24272
View this thread: http://www.excelforum.com/showthread...hreadid=378875

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??


--
terabar
------------------------------------------------------------------------
terabar's Profile: http://www.excelforum.com/member.php...o&userid=24272
View this thread: http://www.excelforum.com/showthread...hreadid=378875