See Debra Dalgleish's website....she has a great
Order Form example and instructions:
http://www.contextures.com/xlOrderForm01.html
Is that something you can work with?
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
"Ruth" wrote in message
...
I have a worksheet that is making me crazy. Basically its a sales order
form
with drop down menus for each set of items based on category. I want the
MSRP
field to autofill with the prices when an item is selected and for this I
am
using the "if" with nesting. But it only allows me to nest 8 and I need
14.
Any suggestions on other functions I can use to accomplish this?