validation dropdown

Hello all, I found a thread which covers my need, however it is limited for 3 columns and I need at least 5. In the thread he say it is difficult to set up it, so I would like to know if you could help me on that. Example Thread

Dropdown Lists / Validation rules Trying to input information across three decisions Dept 2. Sector 3. Reason <tbody> E2 F2 G2 dept sector reason Hoist_Pins Infeed Conveyor 1 </tbody> Using named excel tables I have successfully managed to make a...

My spreadsheet was created in Excel 2007. There are data validations in a few places, all referring to named ranges on another sheet in the same workbook. The drop-down arrows are missing only for one user, who has Excel 2010. Other users have 2007, 2010, or 2013. The dropdowns were working...

I am trying to create a drop down list using Validation. I have a list of names on SSLFirst and on AuxFirst. I need to be able to combine these list so that they both show up in one drop down list in the cell. I can not seem to get them to come together. is it possible. i tried using offset but...

Howdy, I'm working on a spreadsheet that uses a lot of drop-down validation lists. I don't think it matters, but the ranges referenced by validation are all dynamic named ranges. Usually, if you select a cell that has a validation list, you see an arrow appear to the right of the cell. That's...

Please have a look at this screenshot for current problem https://flic.kr/p/zQtxY6 I have an excel spreadsheet with validiation box fields to enter in stock specials quickly. Problem is on MAC not PC. On PC the drop down arrows are perfect aligned. ON mac the drop down arrows are covered by...

I have a workbook with a data entry tab where I have needed to restricted the entry into one of the columns to be consistent. I used a Drop Down list to accomplish this. Next, I have information from this tab copied to other tabs based on certain criteria. This is accomplished with VB. Here is...

Hi, I have a workbook in which there is a sheet (ERP_Query) which is querying our ERP System. It returns data on works orders for our production lines (Production Line, Item no, Description, delivery date, pack count etc). I'd like to create a sheet for each of our 3 production lines on which...

I have to prepare 70+ tables from a data set. In order to take the same information from the data set, I have created a validation list dropdown (in cell A2). The next step (that I need help with) is recording a macro that prints the first table, then selects the next item on the list and prints...

I use Excel to keep track over clients, and the sheets include lists, so that I can easily hide and show the records I need. (I used this tutorial to make the lists: http://spreadsheets.about.com/od/datamanagementinexcel/ss/excel_database_6.htm) (Unfortunately the document is on a secure zone...

Explaining the story may help you guys understand my needs... I am a gym coach. My athletes will come into the gym, perform their session and then head to my computer where they will enter their load from that day. I want it to be as simple as possible for them. I want a drop down menu for...

I am trying to put together a spreadsheet that tracks sales for our company. The first column is "CUSTOMER", the company we sold product to. The second column is "SHIP TO", which location/branch we shipped the product to. Is it possible to type in the customer's name in column A, and have a...

I have created a dynamic data validation list in a worksheet, using nested IF statements and named ranges. The list shows up just fine, however, I am not getting an error when I enter invalid data. I've checked to make sure the error alert is enabled and recreated the data validation a few times...

I have some files with data validation in dropdown lists, and these have been working fine for some time, but suddenly none of the dropdown boxes appear for any of the cells. I've checked all the data validation settings, and even reset them, but still the dropdown menus don't appear in any of...