ExcelBanter - multi functions

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - multi functions (https://www.excelbanter.com/excel-worksheet-functions/243587-multi-functions.html)

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

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