Essentially I would like allow users to only type or select info into a cell from a list based on another worksheets data set.
For example:
If column B is my set of data how can I make a formula that allows a user to type into a field only values that equal a value in side column B, anything that doesn't match B is not allowed (shows an error if the value is invalid).