Linking lists in Excel 2000/2003
I am trying to set up an auto-invoicing form acquiring totals information
from attached time sheets. I would like to set up the time sheets where the
managers can enter a job catagory, from a list, and when he hits enter, the
pay rates (straight & overtime) rates are changed on that line as well. I
have lists for catagory, straight pay & overtime pay.
I know there is a way to link the pay with the catagory but, so far, have
not been able to find it.
|