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.

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.