Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi guys,
kinda stuck on a problem. I am trying to add a validation to an column. At the moment I have staff, hourly rate, job etc i have a staff valdiation in the fact that they can only be staff from a list. What I would like to do is have it so say a member of staff is entered in staff, you then only have ther hourly rates appear as a drop down in rate. btw each member of staff has many rates. Cheers |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Check out the below link
http://www.contextures.com/xlDataVal13.html If this post helps click Yes --------------- Jacob Skaria "cattyboo" wrote: Hi guys, kinda stuck on a problem. I am trying to add a validation to an column. At the moment I have staff, hourly rate, job etc i have a staff valdiation in the fact that they can only be staff from a list. What I would like to do is have it so say a member of staff is entered in staff, you then only have ther hourly rates appear as a drop down in rate. btw each member of staff has many rates. Cheers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Complex Multi-condition, multi-workbook count | Excel Discussion (Misc queries) | |||
Multi-Conditional Functions | Excel Worksheet Functions | |||
match in multi-column and multi-row array | Excel Discussion (Misc queries) | |||
Multi functions | Excel Worksheet Functions | |||
how can I paste multi-line/multi-paragraph data into ONE cell? | Excel Discussion (Misc queries) |