I am new to excel but have a project that has to be done so here goes.
Column 1 needs a dropdown list of Reason Codes (i.e. travel, lodging,
meals, etc)
Column 2 needs a dropdown list of Activity Codes (Management, Training, etc.)
Other columns will have text descriptions and amounts for totaling.

The objective of the Columns with drop downs is so we can prevent someone
from using a Reason Code with an Activity Code that doesn't make sense. So
Say I select Travel, I then go to the next column and the dropdown has only
the codes that are valid for travel.

Next objective
Taking the combined codes (say Reason is Travel and Activity is Management)
I would tally up all those codes, then move on to the next code (say Travel
and Meals)

Each person would have one spreadsheet. Later on I might want to add up all
the spreadsheets using Excell for a grand total of all expense code combos,
but for now, I think I have enough on my plate just to do this.

Can anyone help me?