Dropdown list

[Iamabiff]

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.

 

[Michael M]

Have you checked that the data validation list source data has the last item inlcuded ??
A DV list can contain over 32000 items if required !!

 

[Iamabiff]

Yes, the data validation for products includes column one, rows 2 thru 300. However, I only have cells 2 thru 57 populated. Having cells 2 thru 300 in the validation let's me add product without having to go back and edit lists. I've even went as far as to clear the validation and re-create it and that didn't fix my problem. I hope I understood your question correctly.

 

[Michael M]

OK, can you upload the workbook to dropbox or similar and post a link to the file back here ??
AND
What does this line mean in relation to the DV list

 I've check the name range in the formula section and it all appears OK

 

[Iamabiff]

I posted this once, but I'm not sure it made the trip. Here's the Dropbox link link.

https://dl.dropboxusercontent.com/u/68720320/BBT Blank Order Form Invoice 050815.xltm

One sheet 1 under item description in the drop down list, the last item refers to 14" extensions. On sheet 2 under Products, 14" extensions are in cell A56. I need the A57 on Sheet 2 to be the last item in the drop down list on sheet 1.

Thanks,

Mark

 

[Michael M]

my earlier post asked

Have you checked that the data validation list source data has the last item included ??

If you click on cell A22 of the Order sheet then select Data Validation from the menu, you will see that the Source data formula

=Products!$A$3:$A$56

only goes to row 56 !!

If you add new rows you will need to adjust the source data formula accordingly, OR add a few extra rows in the source data formula for future expansion !

 

[Iamabiff]

Michael,

Thanks you so much. I knew it was something simple. I don't work with formulas and such daily and I built this workbook quite some time ago. I just couldn't remember what I did. And then after adding a couple things, I was totally confused. I really appreciate it.

 

[Michael M]

Glad we worked it out...

 

[sunnyzags]

Could someone help me out here:
I have a VBA code from which a drop down takes value(i m so new to to VBA i am not even sure if that actually happens) but it is taking two values one of which i require, the other one i dont. Please tell me how to edit it? Thanks a lot!

 

[Michael M]

Please start a new thread of your own !