JIGUVAIDYA
New Member
- Joined
- Sep 26, 2008
- Messages
- 7
Dear all,
I have a workbook of my all Training data. in this i have following worksheets
1. summary
2. master (in which i entered employees training data)
3. training needs
4. training plan
Now in Summary sheet i call related data from above different sheets.
My question is, i am using combo box for employee no. and when you click on any no. it will call the relevent data by index function but searching the number from combo box is tidious and time consuming.
So plz suggest a way, is it possible that if i enter just number and search all data? Give me excel code for this.
I have a workbook of my all Training data. in this i have following worksheets
1. summary
2. master (in which i entered employees training data)
3. training needs
4. training plan
Now in Summary sheet i call related data from above different sheets.
My question is, i am using combo box for employee no. and when you click on any no. it will call the relevent data by index function but searching the number from combo box is tidious and time consuming.
So plz suggest a way, is it possible that if i enter just number and search all data? Give me excel code for this.
