create find to select key 4NR
create find for the 1key column L then
and show the ORD number in the output sheet call "KEY"
all the key will need to be find by column itself
column begings with the it self week number selected then 10 more weeks (after)
as shows
29169983--1-.xlsm
and show the ORD number in the output sheet call "KEY"
all the key will need to be find by column itself
column begings with the it self week number selected then 10 more weeks (after)
as shows
29169983--1-.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you select a value in column 'L' doe you also want to look in the other 9 columns, yes or no?
Si selecciona un valor en la columna 'L', ¿también desea buscar en las otras 9 columnas, sí o no?
If your answer is No, do you want me to create 9 more 'KEY' sheets for the other keys, or do you want them to use the same sheet (which would be cleared first every time when a new number is searched for/
Si su respuesta es No, ¿quiere que cree 9 hojas más 'CLAVE' para las otras teclas, o quiere que usen la misma hoja (que se borraría primero cada vez que se busca un nuevo número.
In either case please ask a new question since you didn't ask for that in this question.
En cualquier caso, haga una nueva pregunta, ya que no la pidió en esta pregunta.
Si selecciona un valor en la columna 'L', ¿también desea buscar en las otras 9 columnas, sí o no?
If your answer is No, do you want me to create 9 more 'KEY' sheets for the other keys, or do you want them to use the same sheet (which would be cleared first every time when a new number is searched for/
Si su respuesta es No, ¿quiere que cree 9 hojas más 'CLAVE' para las otras teclas, o quiere que usen la misma hoja (que se borraría primero cada vez que se busca un nuevo número.
In either case please ask a new question since you didn't ask for that in this question.
En cualquier caso, haga una nueva pregunta, ya que no la pidió en esta pregunta.
ASKER
Martin is a great job
It's working as I need it
needed for each column an search button for each key
please
==========================
Martin es una gran trabajo
esta trabajando como lo necesito
necesido para cada columna an boton de busqueda para cada llave
porfavor
It's working as I need it
needed for each column an search button for each key
please
==========================
Martin es una gran trabajo
esta trabajando como lo necesito
necesido para cada columna an boton de busqueda para cada llave
porfavor
ASKER
If you select a value in column 'L' doe you also want to look in the other 9 columns, yes or no?
yes!! please
ASKER
If your answer is No, do you want me to create 9 more 'KEY' sheets for the other keys, or do you want them to use the same sheet (which would be cleared first every time when a new number is searched for/
create 9 more 'KEY' sheets for please!
ASKER
i think create 9 more KEY sheets is more pratcical because i can compare and analyse as needed
ASKER
Great JoB Best EXpert !
ASKER
is an great Job
working as needed for column L
but need one find for each others column for each key
Please !