Excel Search Engine Help

**sajidbagi** · 16th July 2009, 07:17 AM

Aoa

mein apna search engine banana chahta hoon jo full dynamic ho.aur agar ho sakay to jo word bhi mein search karwaoon to results mein sirf woh word highlight ho jayay.

my file is attached

plz help

**Mubashir Aziz** · 16th July 2009, 03:10 PM

Sub say pahli baat aap ko search criteria main batana paray ga kah kiss main search karni hay ???

ITEM#
VENDOR NAME
ERP PART NUMBER
ERP VENDOR CODE
NIMS PART #

Inn main say kissi aik criteria par search laga dain ....

Waisay Autofilter key command bhi achi command hay jiss kay zariay aasani say tamam result mil jatay hain ........ Have you tried that ???? Aap Autofilter main Custom main contains key filed main wild character bhi use kar saktay hain ... jaisay *AL* TO jahan jahan Al hoga woh filter ho jain gay .....

Pivot Table key option bhi buhat achi option hay,

I'll try for other solution as well ......

**sajidbagi** · 16th July 2009, 03:24 PM

autofilter se meinay isay kar liya hai......meinay in sari fields ko concatenate k zariyay alag ek cell mein le kar us par autofilter apply kiya hai aur usay *xyz* se search bhi kiya hai.

**Mubashir Aziz** · 16th July 2009, 04:14 PM

This can be done with macros or some array formulas. Actually today i'm going to my home town and on my return InshaAllah i'll try to solve out your problem but please tell me what you mean by highlight the word ?????
Do you want to see result in search engine sheet ???? can you tell me in excel sheet with some sample words that what you actually want ???
Because jub tuk aap pori requirement naheen batain gay main khud ya apnay friends kay sath aap key problem share naheen kar sakta iss liye aap sheet main sample words ya comment kay zariye batain kah result kiss tarah aaye ??????

**sajidbagi** · 20th July 2009, 07:02 AM

salam bhai my required work book is attached.

**Mubashir Aziz** · 20th July 2009, 08:57 AM

that can done only by using Macro, if possible especially coloring only the teXt with in cells .... its not easy job and as I earlier told that my experties is not in Macro as most of the time i proffered for work sheet functions solutions ........
Anyway i'll try to find out some other possibilities by checking with my friends ......

**sajidbagi** · 21st July 2009, 06:51 AM

mubashir bhai yeh kaam ab jo mein sheet attach kar raha hoon us mein ho chuka hai magar yeh complete data k andar se search kar raha hai however i want to search only with in one field....in (my requirement sheet).

please do something.