I'm looking for a resolution to a problem I'm having in creating an Excel 2007 timesheet. Here's what i want to do.
There is a large list of codes one can select to charge labor too. I created a drop list with the selected codes to choose from, which is about 20-30 codes in the list. Also, hours are entered manually for a specific code. The remaining hours not allocated manually are distributed to a number of codes automatically and calculated against specific codes with percentages.
What I'd like to do is whenever I manually select a specific code to assign hours manually that the selection triggers and changes the percentage value to 0 (zero), so that hours are not allocated twice for the specific code. Another way alos to attack this is a simple check box to turn the percentage to 0 for the specific code.
If you ned more info let me know. Look forward and appreciate your help on this matter.