Is there a wayto prevent order more of an item than what they have already turned in?

Originally Posted by arlu1201

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

The problem with my thread title is the same as the problem itself. If there is a way to do what I am wanting to do I dont know what it is called? How can I make a thread title asking for a spcific function or formula if I dont know what that specific function or formula is? If I knew what the specific funtction or formula was then why would I be posting here asking for help in the first place?

Quiet a conondrum wouldn't you say? I must first ask for help with a specific issue when I dont know the name of the specific issue

Originally Posted by arlu1201

You can rename your thread title to what you are trying to accomplish. For e.g something like Is there a way to prevent order more of an item than what they have already turned in.

There ya go, now on to the problem. Any ideas, anyone?

Originally Posted by dredwolf

try this:
select cell A1, add Data Validation,Allow = Whole Numbers,Data = less than or equal to,Maximum =A2

Hope this helps

PURE GENIOUS ! -- Works like a champ - Thanks a million for your help !

I clicked the "add to user's reputation" button on you as well. Thanks again for your help.