Amygal
05-26-2015, 12:56 PM
Hello Everyone.
I am new to this Forum, I have Intermediate knowledge on Excel I am Not that Great with Formulas and VBA.
From Last week I am trying to sort Data But isn't helping me. ( I tried VBA but I dont have Knowledge of this so dont know how to edit the code)
Please help me out : My Query is
I have 200 + line Items , There are 36 Columns with Headers. I am Looking for a Free Text Search Box Which can help me Search By
Region|Partner|Resource name|Location|Function|Skills(remaining columns are the Skills against which There are yes and No)
This is Kind of a Skill Matrix to search.
Requirements : Guidance required to insert a Free text search Tab as I dont know.
The Header are to be freezed The data Should Populate all the Information related to That search ( All 36 Columns)
I dont neeed a drop down in any of the fields
Example : I would like TO SEARCH For a Manager(role) for Retail( Function) is from Region (India) who know SQL (This SQL is a Header Column) See the Image below how it looks.
13520
I am new to this Forum, I have Intermediate knowledge on Excel I am Not that Great with Formulas and VBA.
From Last week I am trying to sort Data But isn't helping me. ( I tried VBA but I dont have Knowledge of this so dont know how to edit the code)
Please help me out : My Query is
I have 200 + line Items , There are 36 Columns with Headers. I am Looking for a Free Text Search Box Which can help me Search By
Region|Partner|Resource name|Location|Function|Skills(remaining columns are the Skills against which There are yes and No)
This is Kind of a Skill Matrix to search.
Requirements : Guidance required to insert a Free text search Tab as I dont know.
The Header are to be freezed The data Should Populate all the Information related to That search ( All 36 Columns)
I dont neeed a drop down in any of the fields
Example : I would like TO SEARCH For a Manager(role) for Retail( Function) is from Region (India) who know SQL (This SQL is a Header Column) See the Image below how it looks.
13520