C
Cox
I would like to upgrade my services invoice with an associative, drop down
list. The Drop Down List will include all services available (about 40) and
I have figured out how to do this, however, it is the other, associated
cells that I don't understand.
With every service there is "Operated" & "Standby", under each is "Regular"
& "Overtime". I have all of these hourly costs in cells in the same
workbook as the services, and as a hidden part of each invoice. Now here is
the part that I don't understand. When I pick a service, out of the
services drop down list, I would like the hourly prices to appear in the
appropriate cells. In this fashion, all I would have to do is select the
service and put the hours worked in the appropriate "Regular & Overtime"
cells and let the spreadsheet calculate the total costs.
Is this expecting too much from Excel? I am running both Office 2000 &
Office 2003.
(e-mail address removed)
list. The Drop Down List will include all services available (about 40) and
I have figured out how to do this, however, it is the other, associated
cells that I don't understand.
With every service there is "Operated" & "Standby", under each is "Regular"
& "Overtime". I have all of these hourly costs in cells in the same
workbook as the services, and as a hidden part of each invoice. Now here is
the part that I don't understand. When I pick a service, out of the
services drop down list, I would like the hourly prices to appear in the
appropriate cells. In this fashion, all I would have to do is select the
service and put the hours worked in the appropriate "Regular & Overtime"
cells and let the spreadsheet calculate the total costs.
Is this expecting too much from Excel? I am running both Office 2000 &
Office 2003.
(e-mail address removed)