We help IT Professionals succeed at work.

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
mmm111.PNG
s1s1s1.PNG29169983--1-.xlsm
Comment
Watch Question

Social distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
Try this. If you want to see results that have more than one column then select '260' at row 1070.

Prueba esto. Si desea ver resultados que tienen más de una columna, seleccione '260' en la fila 1070.
29170042.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin

is an great Job

working as needed for column L

but need one find for  each others column  for each key

Please !
Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
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.
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
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
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
If you select a value in column 'L' doe you also want to look in the other 9 columns, yes or no?

yes!! please
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
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!
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
i think create 9 more KEY sheets is more pratcical because i can compare and analyse as needed
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Great JoB Best  EXpert !

Explore More ContentExplore courses, solutions, and other research materials related to this topic.