We help IT Professionals succeed at work.
Comment
Watch Question

Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Okay here it is. I've changed the userform in this workbook so that it looks like this. If you need the textbox pointed to by the arrow, please help me understand why.

De acuerdo, aquí está. He cambiado la forma de usuario en este libro de trabajo para que se vea así. Si necesita el cuadro de texto señalado por la flecha, ayúdeme a comprender por qué.
2020-02-08_05-55-36.png
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin

in some situations moving faster  the textbox  help me a lot
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Okay I'll leave it but I think the new checkboxes are easier to use. Is the rest if the workbook okay?

Está bien, lo dejaré, pero creo que las nuevas casillas de verificación son más fáciles de usar. ¿Es el resto si el libro de trabajo está bien?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Yes !!


well the relative  button is not working

but  should be chechk in other question
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
well the relative  button is not working
Please don't make me have to guess what isn't working; tell me.

Por favor, no me hagas adivinar lo que no funciona; Dime.
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin

the realtive button
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
I know you mean the relative button. What I don't know is what you mean when you say it isn't working. All these things could be what you mean when you say it isn't working:
  • When I press the button Excel crashes.
  • When I press the button nothing happens.
  • When I press the button I get the wrong results.

Those are the things that I need to know. When you don't give me enough information I have to guess at what's wrong.

Sé que te refieres al botón relativo. Lo que no sé es a qué te refieres cuando dices que no está funcionando. Todas estas cosas podrían ser lo que quieres decir cuando dices que no funciona:
  • Cuando presiono el botón Excel se bloquea.
  • Cuando presiono el botón no pasa nada.
  • Cuando presiono el botón obtengo los resultados incorrectos.

Esas son las cosas que necesito saber. Cuando no me das suficiente información, tengo que adivinar lo que está mal.
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin   the relative button


When I press the button nothing happens.


Cuando presiono el botón no pasa nada
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Okay here is the problem. The workbook that you originally posted was not set up for 2N. What I mean by that is that there should not be 'Left 3' and 'Right 3' sections as shown in the picture. Hopefully you can find a previous 2N workbook that only has one section under the Relative button. If you can find it then attach it here and I'll make the same changes that I made in 29172063.xlsm.

De acuerdo, aquí está el problema. El libro de trabajo que publicó originalmente no se configuró para 2N. Lo que quiero decir con eso es que no debería haber secciones 'Left 3' y 'Right 3' como se muestra en la imagen. Espero que pueda encontrar un libro de trabajo 2N anterior que solo tenga una sección debajo del botón Relativo. Si puede encontrarlo, adjúntelo aquí y haré los mismos cambios que hice en 29172063.xlsm.
2020-02-09_08-52-41.png
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin

can we do the pairs in column E

then closed the question
 
it will take me some times  to find other 2N workbook

rigth now is not the priority for me
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
No I don't want to do that because as I said, the workbook that you originally posted was not set up for 2N and if I make more changes to it I'd just have to redo them for a proper 2N workbook.

No, no quiero hacer eso porque, como dije, el libro de trabajo que publicó originalmente no estaba configurado para 2N y si hago más cambios, solo tendría que rehacerlo para un libro de trabajo 2N adecuado.
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
I've found a workbook of yours (29152402.xlsm) where we did "relative" for 2N, but in that workbook "relative" looks like the picture below which is very different than the "relative" in the workbook you attached for this question so I don't know what you want to do.

Encontré un libro de trabajo suyo (29152402.xlsm) donde hicimos "relative" para 2N, pero en ese libro de trabajo "relative" se parece a la imagen de abajo, que es muy diferente al "relative" en el libro que adjuntó para esto. pregunta, así que no sé qué quieres hacer.

2020-02-10_05-37-29.png
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin

ok we can use the last one you find will be ok to me
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
What would you like me to do in that workbook?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin

can you send me the last book?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
What would you like me to do in that workbook?

is need do the column E

to find multiple pairs
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Let me show you a trick. (At the end of the video I press Return.)
2020-02-10_07-42-13.mp4
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Why did you choose this post of yours as the solution?
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Also
is need do the column E

to find multiple pairs
Don't you mean column 'A'?

In case you can't get my trick to work, here's the workbook.
29152402.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin

i was posting an comment

for some reason it select the solution  was not me  or my intention
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
I've asked a moderator to undo that selection of the post as a "solution".
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin

ok i see you point now

let that as is

please

keep the  working on file 2N_to_find_pair.xlsm
to column E to work with multiple pairs

because it will be other work
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
I've asked a moderator to undo that selection of the post as a "solution".

Thnaks !!!
"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
keep the  working on file 2N_to_find_pair.xlsm
to column E to work with multiple pairs
I already did that in the 29172063.xlsm file I attached earlier. That workbook has mysteriously disappeared however so I'm attaching it again.

Ya lo hice en el archivo 29172063.xlsm que adjunté anteriormente. Sin embargo, ese libro de trabajo ha desaparecido misteriosamente, así que lo adjunto nuevamente.
29172063.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
I already did that in the 29172063.xlsm file I attached earlier. That workbook has mysteriously disappeared however so I'm attaching it again.

I never see it !! until now

that why i keep asking for  work on it
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Im trying to give the points ! !
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
I never see it !! until now
Okay but what did you mean when you said the relative button isn't working in this post?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Okay but what did you mean when you said the relative button isn't working in this post?

when i hit the button RELATIVE  it don't show the  data as needed

but i saw this in file 4N and 3N

this 2N file look is working

than i understand your confution
but i will need work that some times foward rigth now need work with  tri in file 4N  
i will open an new question for