excel pivot like

%3CLINGO-SUB%20id%3D%22lingo-sub-1625865%22%20slang%3D%22en-US%22%3Eexcel%20pivot%20like%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1625865%22%20slang%3D%22en-US%22%3E%3CP%3EI%20pulled%20all%20clients%20info%20from%20db%20and%20saved%20in%20excel.%20when%20i%20pulled%20i%20used%26nbsp%3B%20'%25clientname%25'%2C%20and%20got%20so%20many%20records%20from%20database.%3C%2FP%3E%3CP%3Eclient%20%3A%20chandu%3C%2FP%3E%3CP%3Erecords%20in%20excel%2Fdb%20as%3A%3C%2FP%3E%3CP%3Echandus%2C%3C%2FP%3E%3CP%3Echandu%20shop%2C%3C%2FP%3E%3CP%3Echandu%20spl%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eone%20sheet%20have%20clientnames%20and%20othersheet%20have%20all%20similar%20clients%20information%2C%20my%20requirement%20is%20to%20when%20i%20clicked%20the%20clientname(ex%3Achandu)%20and%20it%20should%20display%20all%20details%20(ex%3A%20chandu%20shp%2Cchandus%20%2Cchandu%20shop%20etc%20simply%20%25chandu%25)%20.Please%20someone%20help%20me.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1625865%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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:

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.

0 Replies