Hi...All Excel Expert & Pro,
Need some guidance to create Search Engine to find match data again the input made by the User, example Data attached.
DATA SHEET :
PG Division Div. Head Dept Staff No User Name Approving Limit Approval Code
101 Group CEO’s Office Ahmad Jauhari Yahya Ext Relation 1176503 Nor Zalida Ahmad RM 0 - RM 50,000 AB
101 Group CEO’s Office Ahmad Jauhari Yahya Ext Relation 1176503 Nor Zalida Ahmad RM 50,000.01 - RM 250,000 HB
101 Group CEO’s Office Ahmad Jauhari Yahya Ext Relation 1176503 Nor Zalida Ahmad > RM 250,000 OB
PURCHASED APPROVAL CODE SEARCH
Purchasing Group : 101
Approving Limit : > RM 250,000
RESULT
PG Division Div. Head Dept Staff No User Name Approving Limit Approval Code
101 Group CEO’s Office Ahmad Jauhari Yahya Ext Relation 1176503 Nor Zalida Ahmad > RM 250,000 OB
Hope can create user friendly SEARCH Engine for my user.
Thanks.
Rgds.
Mazlan
Bookmarks