Use data=Validation using the list option for the dropdowns

Use a pivot Table (Data=Pivot Table Report)
to get summarized numerical information

--
Regards,
Tom Ogilvy


"JaneAnderson" wrote in message
...
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?