Forum Discussion
Excel lista desplegable
Hi Isabelma5
First, simplify it, don't start referencing ranges in another workbook.
Make sure your Drop down List Sheet is in the same workbook. This is why you receive an error message Cannot find the specified range
or you can share your workbook privately and I'll set it up right now and send it back to you. my e-mail
is: exo7450 at comcast dot netI tried referencing a data validation range from another workbook and received the error message, see image below:
Also note how I have defined the
Centers drop-down selection list, it is defined as a spill range using the . UNIQUE(Table1[[[[#All],[All]])Also note that the validation range of the drop-down menu ends with a
which is important if your drop-down selection is a spill range: 'DropDownList!$D$2' #
Let me know if you have any other questions or clarifications about it.
Bless you
Hola Isabelma5
Cometí un error y olvidé usar el rango derramado en la selección desplegable. Pruebe esto y avíseme si hay problemas.
Salud
Me temo que ahora no se despliegan los centros de la lista dinámica....
Gracias por tu ayuda
Hola Isabelma5
No estoy seguro de por qué no funciona al final, pero vea las capturas de pantalla a continuación para ver si funciona bien
SaludFíjate en lo que me sale cuando voy a validación de datos en la celda desplegable del centro:
Hi Isabelma5
First, simplify it, don't start referencing ranges in another workbook.
Make sure your Drop down List Sheet is in the same workbook. This is why you receive an error message Cannot find the specified range
or you can share your workbook privately and I'll set it up right now and send it back to you. my e-mail
is: exo7450 at comcast dot netI tried referencing a data validation range from another workbook and received the error message, see image below:
Also note how I have defined the
Centers drop-down selection list, it is defined as a spill range using the . UNIQUE(Table1[[[[#All],[All]])Also note that the validation range of the drop-down menu ends with a
which is important if your drop-down selection is a spill range: 'DropDownList!$D$2' #
Let me know if you have any other questions or clarifications about it.
Bless you
- Pues la verdad no entiendo cuál puede ser el motivo por el que a mí no me da opción a desplegar la lista de centro.... en la de año y mes no tengo problema, pero cuando intento desplegar la de centro, no me da opción a desplagarla.... veo tus pantallazos y están perfectos pero no entiendo el porqué de cuando descargo el archivo e intento seleccionar centro no me lo permite...
Gracias por tu ayuda!