I have an expense report I am trying to make stupid simple for my employees.
I have a worksheet called €œDetailed Expense€� they fill out. They input
their expenses and cost- code them. I have figured out a way to calculate
the total for each code selected (probably not the most efficient way) but
that works. I have another worksheet called €œFinal Expense Report€�. This
sheet has the totals for all codes in their appropriate categories. (ie:
Travel, Mileage, Hotels, Meals, Airfare, Per Diem) The issue : people
multiple have / work on multiple projects, they could potentially have four
different cost codes for Airfare. Each cost code used and its total must be
listed on the €œFinal Expense Report.€� Totaling all the airfare codes is easy.
However, having each airfare code auto-populate in the final separate code
totals on the €œFinal Expense Report€� has thrown me for a loop. I could just
put all the Cost Codes on the sheet and then have the total, but I dont want
to put 300 Cost Codes on the €œFinal Expense Report€�€¦
Any help is appreciated..