excel pivot like

Occasional Contributor

I pulled all clients info from db and saved in excel. when i pulled i used  '%clientname%', and got so many records from database.

client : chandu

records in excel/db as:


chandu shop,

chandu spl etc.


one sheet have clientnames and othersheet have all similar clients information, my requirement is to when i clicked the clientname(ex:chandu) and it should display all details (ex: chandu shp,chandus ,chandu shop etc simply %chandu%) .Please someone help me.

0 Replies