Hi,
I've created a drop down list in an invoice. The invoice is page one. It populates from from page two with item and price. I have 57 items in my product list. I've created the data validation and have the list going to row 300. This allows me to enter new items with more ease and not have to edit data etc. My problem is this: On the drop down in my invoice it only show products 1 thru 56 the product item in row 57 does not appear in the drop down. I've check the validation and it appears to ok. I've check the name range in the formula section and it all appears OK. If I choose an item from the drop down and then try to manually change it to to match what I need in row 57 of the products it tell me"The value you've entered is not valid. A user has restricted values that can be entered in this cell. I'm stumped.
I've created a drop down list in an invoice. The invoice is page one. It populates from from page two with item and price. I have 57 items in my product list. I've created the data validation and have the list going to row 300. This allows me to enter new items with more ease and not have to edit data etc. My problem is this: On the drop down in my invoice it only show products 1 thru 56 the product item in row 57 does not appear in the drop down. I've check the validation and it appears to ok. I've check the name range in the formula section and it all appears OK. If I choose an item from the drop down and then try to manually change it to to match what I need in row 57 of the products it tell me"The value you've entered is not valid. A user has restricted values that can be entered in this cell. I'm stumped.