I managed to convince my manager to settle for less.
He wanted a drop down list in excel where you could select departments.
Now excel has a drop down, and that is even within my limited knowledge.
But with only one selection option, so I am already copying and pasting code without knowing what it precisely does.