data validaton

I have a sheet that I created for work that I'm having some problems with. First, here are some details about the sheet: Using Excel 2007 It's password protected. Users are only able to select locked and unlocked cells, format rows and columns, and use autofilter. It contains several index...

Hi, I'd appreciate help with this problem. I'm trying to restrict entry in a cell to a date or, if specific text is entered in the adjacent cell, allow the user to type permitted text. The cell I'm restricting is a project deadline date. So if the user selects "on hold" in the satus cell...

Hi, I am trying to create a simple solution to allow the contents of a drop-down data validation list (within a table) be determined by the value of a cell 2 columns to the left of the drop-down cell; a Name -> Job relationship. Workbook after the link >...

Hi, I've been searching the web and so far had no joy in finding a solution to what I need, I'm hoping someone can help. I am pretty basic with macros having only used them a handful of times at a very simple level. I have built a report that will provide users with a data output based on the...