add userform to columns

Do you want

1- ...column  from AL to AZ

or do you want

3- ...columns  from  columns D to AZ

ok we are talking about two different situations

1-one is what columns are going to be in the useform (but not as keys)


2- another is that columns are going to be keys

Are AL to AZ the keys?

yes

If AL to AZ are the keys then it doesn't make sense to me that D to AZ should be the columns. The columns should probably just be M to P with D also showing up in the output.

Si AL a AZ son las claves, entonces no tiene sentido para mí que D a AZ deberían ser las columnas. Las columnas probablemente deberían ser solo de M a P con D también apareciendo en la salida.

That doesn't make sense either, so please give me an example of the columns  and keys you might select.

Well what I'm looking for is to see comparisons

and here we have a good opportunity to compare according to the situation

when I talk about the columns to see in the userform

I mean that from column D to AZ I can choose which would be the output as needed


for example first user form in column R3

column R is the key so I can choose according to need from D to AZ the columns that I need to compare

columns K would always be in the output

Rather than having more than 20 userforms on the CONSE worksheet, would it be okay if there was just one userform that requires you to first select the key column?

En lugar de tener más de 20 formularios de usuario en la hoja de trabajo CONSE, ¿estaría bien si solo hubiera un formulario de usuario que requiera que primero seleccione la columna clave?

Yes!!!

that would be Tera!

I'm still having trouble understanding what you need, so please describe what you want to see in the userform after column 'R' is selected.

Sigo teniendo problemas para entender lo que necesita, así que describa lo que desea ver en el formulario de usuario después de seleccionar la columna 'R'.

a button in R3 call it "1"
this button will open a userform

using will have column R as key

and I will be able to select from columns D to AZ with a checkmark

similar to this shape

this only for R3 and R columns


and so for the others

The detail is that each column is a different key
  and you have to make a user form for each one

In the userform the numbers in the ORDs column will always be the same. True or false?

True

but that is because we use the ORDFORM as sample  so ORD  is the Key (sheet1  BF1)

So if after selecting your proposed button "1" and selecting column 'AM' in the userform, how would the output be different if I select button "2" (assume it is in column s) and select column 'AM' in the userform?

Entonces, si después de seleccionar el botón propuesto "1" y seleccionar la columna 'AM' en el formulario de usuario, ¿cómo sería diferente la salida si selecciono el botón "2" (supongo que está en la columna s) y selecciono la columna 'AM' en el formulario de usuario ?

Excuse me, I should have talked about the AL column, not the R column.

AL is the key and the other columns would be in the columns section to be selected with a check mark as needed


if later I wanted to do the column AM

I would have to have an AM3 button that would open a userform with the Am column as the key and columns to select

So are you saying that there will always be just one entry in the userform's left column? If so then we don't need the left userform column as long as somewhere in the userform I show "AM"). Do you agree?

Entonces, ¿estás diciendo que siempre habrá una sola entrada en la columna izquierda del formulario de usuario? Si es así, no necesitamos la columna de formulario de usuario de la izquierda siempre que en algún lugar del formulario de usuario muestre "AM"). ¿Estás de acuerdo?

Do you agree?

ok I Agree

( in this sample column AL is the Look Up column  then it call the others relatives )

I don't get it. Let's assume you click button "1", and then you select columns M and AM as the columns. Please use the SETS sheet to show me a picture of the first few rows of what you would like the results to look like.

Best  Expert !!!  the best way to explain it in a few words

Why don't you use the form in sheet sheet1 BF1

the ORDFORM button is the best example

but this time applied to the CONSE sheet

and so on for 1 2 3 4 5 6


I would have to make a button for home one

Okay I can do what ORDFORM does but why did you talk about a button on column AL, AM, etcetera?

AL is an Key column

AM is an Key column

AN is an key column  

same to AZ column

I am parsing the keys by column

the userfom (how is ORDFORM) does not let me select the keys only the columns that accompany the key

that means I need a button for each column which is a key

Let's assume you click button "1", and then you select columns M and AM as the columns. Please use the SETS sheet to show me a picture of the first few rows of what you would like the results to look like.

Please do what I asked you to do.

Suppose I have a button in AL3 called 1
I press it and I get a list of values for column AL
(keys) then I select all the keys that contain 4666

this is the output for my selection 

it would be helpful to be able to select the columns that I want to see in the output

Try this. This is just a test to see if the userform shows what you want.
29230885.xlsb

a marvel !!

is not working but is in the best way ToGo

What do you mean when you say "is not working"?

after i made the selection

ok is not avaliable

but it is the necessary functionality once it is finished

Did you see this comment of mine?

This is just a test to see if the userform shows what you want.

good to go 

 use "Center Across Selection" instead. 

ok 

Working !!

can be columns R to W and columns AA to AF and AJ ?? in the columns to be selected
so i cant have to be back for 

Are you referring to columns that can be selected before the userform is shown?

¿Se refiere a las columnas que se pueden seleccionar antes de que se muestre el formulario de usuario?

Are you referring to columns that can be selected before the userform is shown?

ok i need see them after i select the key (in the select with check mark section)

something that I also need is to see the selected column in the output

I don't think it's practical to include R to W in the columns that can be selected, and that's because
1) If you choose a number like 01 in column R, it will result in 125 columns on the SETS sheet and in my opinion that's too many to understand, and
2) that will take a VERY long time

No creo que sea práctico incluir R a W en las columnas que se pueden seleccionar, y eso es porque
1) Si elige un número como 01 en la columna R, resultará en 125 columnas en la hoja SETS y, en mi opinión, son demasiadas para entender, y
2) eso tomará MUCHO tiempo

I agree, very well thought out

but I don't want them to be keys but rather that I can select them with the key

that is, after selecting the key

R to AJ are already in the 'Columns' column. So what if anything do you need me to do?
R a AJ ya están en la columna 'Columns'. Entonces, ¿qué pasa si necesitas que haga algo?

you're right it's there

it's a great job


Great Job Best Expert!

Just The Very Best !