I've had a search and found lots of threads on this but not one that answers my problem. This isn't how my spreadsheet is but the quickest way I can explain what I need:
A1-A4 - Are staff wages
C1-C6 - Are separate expenses
D1-D6 - Are each the same drop down list of staff names who need the...