Avatar of ADRIANA P
ADRIANA P
Flag for United States of America asked on

create look for ord 4N

4n to add usefrom for ord

29224563b.xlsb


1- add an button  in BF1  call it ORDFORM


2-then add userfrom like  the one in PAIR SETS

but now using ORD like the  keys 


3- in the userm form call PAIRS Sets need add  The columns :


BQ BR BS BT BU BV BW


CO AND CQ


Microsoft ExcelVBAMicrosoft Office

Avatar of undefined
Last Comment
ADRIANA P

8/22/2022 - Mon
Martin Liss

In PAIRS SETS there is a list of about 35 columns that you can choose from. In ORDFORM do you always want to look at the 9 columns you listed or would you sometimes want to look at less columns or more columns?

En PAIRS SETS hay una lista de aproximadamente 35 columnas entre las que puede elegir. En ORDFORM, ¿siempre desea ver las 9 columnas que enumeró o, a veces, desea ver menos columnas o más columnas?
ADRIANA P

ASKER
Well I prefer to see 35 because later if I need them and I can not call them, I have to do everything again

I do not call all of them at the same time, it varies according to the need of the moment
but if I need to see they are there and I can call them
are available in case you need them

Martin Liss

Where do the counts go?
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
ADRIANA P

ASKER
Where do the counts go? 

in this situation  the ORD  will be the KEYS


if I understood the question correctly
Martin Liss

No, in PAIRS SETS the results go in columns CO, CP and CQ. Where do the results for ORDFORM go?

No, en PAIRS SETS los resultados van en las columnas CO, CP y CQ. ¿A dónde van los resultados de ORDFORM?
ADRIANA P

ASKER
i need to explain

PAIRS SET button creates a userfrom that does a LookUp and then creates a BYSET


that's what I need in ORD FROM


In the button of 2WEEKS PAIRS that was the last one we did, it is the one that creates the columns CO, CP and CQ


If I want to add the CO CQ Columns to the list of the Look up columns in the userform because in the first one that we did, it was PAIRS SETS, those columns were not the last that we did.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Martin Liss

You are correct. I was looking at the wrong button.
ADRIANA P

ASKER
:)
ASKER CERTIFIED SOLUTION
Martin Liss

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ADRIANA P

ASKER
Great Job Best Expert!

All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ADRIANA P

ASKER
can be

BQ BR BS BT BU BV BW

CO AND CQ added to the list in the userform ?
Martin Liss

In this version I
  • Added the 9 new columns to the userform when doing ORDFORM
  • Removed column BF from the userform when doing ORDFORM
  • Changed "Keys" to "ORDs" on the userform when doing ORDFORM
  • Se agregaron las 9 nuevas columnas al formulario de usuario al hacer ORDFORM
  • Se eliminó la columna BF del formulario de usuario al hacer ORDFORM
  • Se cambiaron "Claves" a "ORD" en el formulario de usuario al hacer ORDFORM

I noticed a problem. The highlighted ORDs are not in the correct order.
Noté un problema. Los ORD resaltados no están en el orden correcto.
2021-09-20_05-47-09.png
When I looked further I found that it's a bigger problem.
Cuando miré más allá, descubrí que es un problema mayor.
2021-09-20_06-28-04.png
Please verify that the listed ORDs are in fact incorrect and I'll fix them.
Verifique que los ORD enumerados sean de hecho incorrectos y los corregiré.
29224637a.xlsb
ADRIANA P

ASKER
Please correct them


Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ADRIANA P

ASKER
Thanks for identifying those issues.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ADRIANA P

ASKER
Great Job  
Best  Expert !