Value from List Box?

  • Thread starter Thread starter Outlook, eh?
  • Start date Start date
O

Outlook, eh?

Hello,
I am revamping a timesheet in Excel and was wondering how to make all values
in a list box equal 8.
For example,
I have a drop down box for Holiday, Sick, Personal and when a user selects
one of these types 8 hours will appear in a total hours box.
Any help would be great!
Thx
-B
 
Great formula! I am sure I posted this before but I was just wanted to get
your thoughts on what are the possible places that a list (source) for data
validation can be stored? I am working on someone else's timesheet and when I
click on a cell and check the data validation it is referring to a list that
I can't find. Obviously I checked the one tab, but it had another validation
list. This is a free-floating file, which means it is being copied and saved
all over the organization, so I don't think the list refers to another Excel
file. Any ideas? Thanks!
 
Back
Top