I know the Data validation/List option to use a pre-defined list of (in my case) Companies, but now I'm searching for a way to create Department lists, based on the already filled Company value.
So, if Company = Site Italy, the Department field should only list the Italian Departments.
Is there an option for that in Excel?
Bookmarks