Try using a pivot table. Select Data, PivotTable and PivotChart Report,
Select the first option "Microsoft Office Excel list or database, select the
range of data and click finish. Place the items on the pivot table in the
areas you want.
Gary

"dinadvani via OfficeKB.com" wrote:

Hello everyone,

I have an excel sheet that has some registration nos., account names,
reference nos and revenue collected against each reference no.

Some what like in this format:

Registration No. Account names Reference no. Revenue
collected
12 ABC 01
1000
18 ADC 04
500

Now I have to prepare a window wherein if I click any account names, then it
should display all the regestrations nos. reference nos and revenue amount.


Please help me, as I don't have any clue about this.

Regards,
D

--
Message posted via http://www.officekb.com