Recent content by Kareem_Abolfotoh

Thanks guys for all replies, but actually I wanna know how can I do that through Combo box? if you can help me, I would be appreciate Combo box or validation list and all rows below change depend on it Thanks

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...