May 11 2021 01:22 PM
May 12 2021 05:49 AM
May 12 2021 07:04 AM
May 12 2021 05:43 PM
May 13 2021 02:52 AM
May 13 2021 12:48 PM
May 13 2021 12:50 PM
May 13 2021 12:55 PM
Hi @Isabelma5 ,
Abrí el libro de trabajo e hice la misma selección y funciona, me pregunto cuál podría ser el problema. ¿puedes compartir el libro errante?
May 13 2021 01:28 PM
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
May 14 2021 11:58 PM
May 15 2021 12:40 AM - edited May 15 2021 12:42 AM
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
Salud
May 15 2021 05:17 AM
May 15 2021 05:23 AM
Fíjate en lo que me sale cuando voy a validación de datos en la celda desplegable del centro:
May 15 2021 04:39 PM - edited May 15 2021 04:43 PM
SolutionHi @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 net
I 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
May 16 2021 01:25 AM
Hola @Isabelma5
¡Finalmente eh, todo ese trabajo duro! Debe sentirse aliviado y satisfecho con su determinación. ¡Date un capricho con un taco o enchiladas y algo de limonada! Buen trabajo Isabelma5 !!!!!
Salud!!
May 16 2021 03:03 AM
Agregué otra funcionalidad para que se pueda buscar en la lista desplegable. Para que juegues.
see attached version 3
Es posible que algún día tenga una lista realmente grande que, cuando escriba las primeras letras de su nombre, limitará la lista a solo los nombres que las tienen dentro.
May 16 2021 03:06 AM
May 15 2021 04:39 PM - edited May 15 2021 04:43 PM
SolutionHi @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 net
I 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