Emp. # Name Pen Unit Price Pencil Unit Price....TOTAL


TOTAL

Ehat I am trying to create is a template in which my
employees can order item which they need. Above it a
basic example of my headings. I would like to be able to
do 2 things with this template. When they key in the
number of units i would like to have a running total of
units and price amounts for each item as well I would like
to have a grand total for each employee. So lets say
Employee A needs 2 pens and 1 pencil....how would i go
about setting this up? Please advise. Thanks