YouTube home Comedy Week on YouTube
Upload

Lista Desplegable y Validación de Datos en Excel 2007

Jorge Ulises Rivera Jorge Ulises Rivera·22 videos
125
127,867
Like     Dislike 8

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to like Jorge Ulises Rivera's video.

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to dislike Jorge Ulises Rivera's video.

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to add Jorge Ulises Rivera's video to your playlist.

Uploaded on Apr 27, 2010

Elaborado por Ulises Rivera. Universidad de Ciencias Comerciales. UCC. Managua. Nicaragua.

  • Category

  • License

    Standard YouTube License

Loading icon Loading...

Loading icon Loading...

Loading icon Loading...

The interactive transcript could not be loaded.

Loading icon Loading...

Loading icon Loading...

Ratings have been disabled for this video.
Rating is available when the video has been rented.
This feature is not available right now. Please try again later.

Uploader Comments (Jorge Ulises Rivera)

  • julgar821

    hola muy bueno tu tutorial pero tengo una pregunta como tomar la lista de una hoja diferente? gracias por atenderme

    ·

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate julgar821's comment.

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate julgar821's comment.
  • Jorge Ulises Rivera

    Si se puede, lo que tenes que hacer es lo siguiente: Poner la lista de datos en la hoja que deseas, ponele un encabezado y nombras esa Lista por ejemplo : Areas, luego en la otra hoja donde queres validar los datos lo que tenes que hacer es poner en Permitir : Lista y en origen de los datos poner =Areas, no se te olvide el signo de =

    ·

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate Jorge Ulises Rivera's comment.

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate Jorge Ulises Rivera's comment.
    in reply to julgar821 (Show the comment)
  • jalopezhe10

    Mira, super bien tu tu tutorial, pero tengo un problema, cuando repito un dato mas abajo de la lista desplegable no me cambia el dato, sigue apareciendo el error, ¿Por qué?

    ·

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate jalopezhe10's comment.

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate jalopezhe10's comment.
  • Jorge Ulises Rivera

    Mandame el archivo a mi correo para ver que estas haciendo mal, recorda de utilizar los signo de $, mejor mandame el archivo a morazanj@gmail.com

    ·

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate Jorge Ulises Rivera's comment.

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate Jorge Ulises Rivera's comment.
    in reply to jalopezhe10 (Show the comment)

All Comments (71)

Sign in now to post a comment!
  • jose lopera

    JORGE , Mil gracias por toda tu ayuda , implemente esto a una base de datos que tengo , y esto cada vez lo absorbe mas y mas a uno , quisiera saber si lo querrias revisar y hacerme alguna sugerencia.

    ·

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate jose lopera's comment.

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate jose lopera's comment.
  • Andrea Belen

    ¡Que excelente! Muchas gracias.

    ·

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate Andrea Belen's comment.

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate Andrea Belen's comment.
  • ochavam16

    Dema Bueno.XD

    ·

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate ochavam16's comment.

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate ochavam16's comment.
  • Jhonatan S

    sta super el video gracias

    ·

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate Jhonatan S's comment.

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate Jhonatan S's comment.
  • Juana garcía

    EXCELENTE EXPLICACION, MUCHAS GRACIAS POR TU DEDICACION. QUISIERA SABER CUANDO PONES LA FORMULA PARA CORREGIR EL ERROR, ¿´QUÉ SIGNIFICA EL CERO?

    JUANA GARCIA DESDE ESPAÑA

    ·

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate Juana garcía's comment.

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate Juana garcía's comment.
  • Jefferson Santiago

    Muy buen video, muchas gracias

    ·

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate Jefferson Santiago's comment.

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate Jefferson Santiago's comment.
  • Eliezer Vásquez

    Felicidades Jorge por tus aportes!... Dios te bendiga!

    ·

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate Eliezer Vásquez's comment.

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate Eliezer Vásquez's comment.
  • José Yarlequé

    Buen dato, felicitaciones

    ·

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate José Yarlequé's comment.

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate José Yarlequé's comment.
  • Pb López

    Hola, necesito saber como puedo crear una lista donde al seleccionar algún texto de la lista, genere un macro. Esperare sus respuestas por favor!!!!!!!!

    ·

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate Pb López's comment.

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate Pb López's comment.
  • EL GATO ALIENS

    HOLA MUCHOGUSTO NECSITO COMO VALIDAR PAISES Y CIUDADES Y ENTONSES CUANDO CAMBIAS EL PAIS TAMBIEN CAMBIA LA CIUDAD ESPERO SU RESPUESTA

    ·

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate EL GATO ALIENS's comment.

    Sign in to YouTube

    Sign in with your YouTube Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to rate EL GATO ALIENS's comment.
  • Loading comment...
Loading...
Loading...
Working...
Sign in to add this to Watch Later