Links in Excel

[terabar]

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?

[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


"terabar" <[email protected]> wrote in
message news:[email protected]...
>
> 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]

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

[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


"terabar" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[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


"terabar" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[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


"terabar" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[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


"terabar" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[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


"terabar" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[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


"terabar" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[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


"terabar" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[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


"terabar" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[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


"terabar" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>