Hi,
I'm pretty new to excel, but Ive managed to make a basic estimate form for the company I work at.
I have it almost perfected, but I want to make it so when a person selects an item from a drop down box, or writes an item in a blank cell, they are prompted for a low end value and a high end value and then these values automatically put in the corresponding high and low end quantity boxes.
Can anyone tell me how to do this? I can upload a copy of the entire form if needed.
Thanks
-Jordan