Hi all. I know that this thread is multiple times posted but i wasn't able to take what i wanted.
I have an excel sheet that contains horizontally the multiple departments of a company that splits on the various subdivisions and later on on the various role positions. The list is horizontal and what i am trying to achieve is a cascade drop down list so that the user first selects the department, and on the next cell the list to be updated with only the subdivisions available on that department and finally based on that selection to be able to select on the next drop down list the roles specific on that department.
I tried a lot of online tutorials even with macros but couldn't get what i wanted. Any help appreciated.