RE: Vlookup Help by Tkawika
Tkawika
Fri Sep 05 18:48:05 CDT 2008
Thanks for the response. I thought about the filter idea and it would seem
to work with the users doing it. There should be a way with IF and Then
statements to create a list out of a list without repeating the items. For
instance:
When the employee puts the expensable item in the list, they would code that
item. IF I created a custom list out of that columns of CODES, Like relist
them in the Expense Report but only put the code once as so not to repeat.
So if you code three items as MEALS30002 and three other different codes in
the detail list. On the report side it list MEALS30002 once and the other
three codes below it. My brain isnt working so well anymore...
Does that make sense?
"J. Andrew Smith" wrote:
> Two suggestions:
>
> 1. You can go ahead and list all the cost codes, but you could use data
> filtering to suppress the ones with zero amounts.
>
> 2. You could group the cost codes by project or some other category, then do
> totals based on the category.
>
> --
> J. Andrew Smith
> Senior Systems Analyst
> Standard & Poor''''''''s, NYC
>
>
>
> "Tkawika" wrote:
>
> > I have an expense report I am trying to make stupid simple for my employeeâ??s.
> > 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 donâ??t want
> > to put 300 Cost Codes on the â??Final Expense Reportâ??â?¦
> > Any help is appreciated..
> >