Kareem_Abolfotoh
New Member
Actually I'm a new member in Chandoo website and I'm amazing with this great site
I have an excel sheet (headcount report) as follows:
ID - Name - Position - Grade - Department -
I need to do in a separate sheet the following
Combo box contains Departments
and by select the department the range of cell below the combo box change depend on it.
it means the field (ID,Name,Position, Grade) in the separate sheet appears for related department only
How can I do that ?
I have an excel sheet (headcount report) as follows:
ID - Name - Position - Grade - Department -
I need to do in a separate sheet the following
Combo box contains Departments
and by select the department the range of cell below the combo box change depend on it.
it means the field (ID,Name,Position, Grade) in the separate sheet appears for related department only
How can I do that ?