Forum Discussion
Excel Data Validation
Hi, I am working on an excel sheet where I want the input of a cell in a data entry sheet to be either a drop down option or a 6 digit number, depending on the input in the cell above. The above cel...
You could help us help you if you gave a bit more information about
(a) how you've managed to create the drop down list when it's NOT "Other"?
(b) when a person selects "Other" are any random 6 digits acceptable, or is that too a constrained list?
Ideally, you would also post a copy of the spreadsheet you have created so far -- posting it on OneDrive or GoogleDrive with a link here that grants access to it. (In the absence of that, you're asking us to do a lot of guessing on your format, the source of the list you already have, etc.)