Hello, can you elaborate on your question?
Hello Liz, I will opt out so we can find someone who is more experienced with spreadsheet's to help you better.
would really need to see an example of what you are trying to do to be able to help
sorry, there is a timezone difference here, You contacted me late at night when I was sleeping. So it will make communication a little difficult.
It is possible to create multi select drop downs, but this requires programming which I can certainly help with.
I'm not exactly following what you are trying to populate. Are you trying to populate the first sheet, where it lists selections one in each of the first few columns. And then each of the selected departments and you call them going on its own line?