• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dynamic Selection

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 ?
 
Hi Kareem,


Do you have any proof, to proof that,

YES.. above is VERY IMPORTANT for all over the world.. Who ever is reading/surfing/trying to help this forum..!!!


By the way, Welcome to the less important Forum..

Please read a really VERY IMPORTANT post mentioned below..

http://chandoo.org/forums/topic/phd-forum-posting-rules-etiquette-pls-read-before-posting


Regards,

Deb
 
Good day Kareem_Abolfotoh


What may be important to one person may mean absolutely nothing to the next, the forum members are all volunteers and will help where they can, they do not like being pushed...but having said that you may find these links of help


http://www.contextures.com/xlDataVal02.html


http://www.myonlinetraininghub.com/excel-data-validation-with-dependent-lists
 
@Debraj Roy, b(ut)ob(ut)hc

Hi!

Good afternoon for both of you.

Just passed by a few minutes ago, saw that title and couldn't resist the temptation.

Regards!
 
@Kareem


Have you thought about putting your data into a PivotTable? You could put the Deparment field in the Page_Area, and then it would function exactly like you describe, with you able to choose from a dropdown and it would change what data you see.
 
Good evening SirJB7


I did consider deleting parts of the OPs title but I thought that as a newbie they would not find there post :(
 
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
 
Good day Kareem_Abolfotoh


The links I posted answer your last post regards data validation, but if you need the combo box to have data validation take a look here,


http://www.contextures.com/xlDataVal10.html
 
Back
Top