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:
chandus,
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.