Help With a Formula
When using a reference in another worksheet for data validation, you have to
use a named range. Assume you name your cell "MaxValue", then goto your
other worksheet and select Data/Validation
Allow: Whole Number (or decimal maybe)
Data: Less than or equal to
Maximum: =MaxValue
"ds_shades" wrote:
I have a Workbook that I am working on that has multiple worksheets in them
What I have done is created a setup tab
On the setup tab I have In Column A I have Various values entered in usually
in sequential order
In Column B is the Maximum Value that can be entered in if someone chooses
something from Column A
In worksheet 2 I have created a List that contains the values from
Setup!A2:A40
I want to have Data validation work so that no one can enter a value above
the number entered for the Value in Column B of Setup!B(Whatever)
Any help on this would be appreciated cause I can not seem to get it to work
the way I want it.
|