Dropdown list

Iamabiff

New Member
Joined
Feb 5, 2014
Messages
17
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.
 
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 !!
 
Upvote 0
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.
 
Upvote 0
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

Code:
 I've check the name range in the formula section and it all appears OK
 
Upvote 0
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
 
Upvote 0
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
Code:
=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 !
 
Upvote 0
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.
 
Upvote 0
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!
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top