Dear friends
I have a sheet with multiple companies & further their own multiple projects. i have setup data validation for each company with respect to their own projects
For example : if i select particular company cell c5 it shows the project of that company on d5. ( NOTE: all data validation is on 2nd sheet )
now i have been using combobox for c5 value ( i have linked combobox to c5 and then entering linkcellrange with Data validation of companies name )
i want to add 2nd combobox which can extract list range of selected company in combobox 1
Bookmarks