Link to home
Create AccountLog in
Avatar of ADRIANA P
ADRIANA PFlag for United States of America

asked on

create user-form key and company columns column E to J in 2N

29258195 (1).xlsm 2n




1-create a look-up using a user form  


2-for keys columns:   E  F  G  H  I  J 


3-in the columns Sections of the user form:  columns: 

E  F  G  H  I  J  K  L  M  \O Q R S T U V W X Y Z  AA AC AD  AE AF AG AJ AK AL AM AN

AO AP AQ AR AS AT AU AV AW AX BF BG BH BI BJ BN  CX CZ DB DC  DD  DF  DH  DI DL  DN DP DV DY EA EE EF EG  EK EL EM FH FI FJ FK FL FM FN FO FP FQ FR FS FU FW FY GA GC  GE GG


Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Try this.
29258222.xlsm
Avatar of ADRIANA P

ASKER

an error is in the SET sheet after select  94  from  94

User generated image
It's very hard to read your pictures. Please find out what you are doing wrong by asking a question about picture taking.

Which column and value(s) did you select?

Es muy difícil leer tus fotos. Averigüe qué está haciendo mal haciendo una pregunta sobre la toma de fotografías.

¿Qué columna y valor(es) seleccionó?
an error is in the SET sheet after select  94  from  Column E
a38.PNG
The picture is much better, thank you, but I still need to know which column you selected.

La imagen es mucho mejor, gracias, pero todavía necesito saber qué columna seleccionó.
Column E
The problem is occurring because at about row 5764 the NUM and ORD values are not in the same row as shown in this picture (where i've hidden most of the columns in between the two). I will fix that.

El problema ocurre porque aproximadamente en la fila 5764, los valores NUM y ORD no están en la misma fila que se muestra en esta imagen (donde oculté la mayoría de las columnas entre los dos). Arreglaré eso.
User generated image
ASKER CERTIFIED SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Great Job
Best Expert !
You’re welcome and I’m glad I was able to help.

If you expand the “Full Biography" section of my profile you’ll find links to some articles I’ve written that may interest you, including a new one concerning Easy Ways to do Hard Things.

Marty - Microsoft MVP 2009 to 2017
        Experts Exchange Most Valuable Expert (MVE) 2015 and 2017
        Experts Exchange Distinguished Expert in Excel 2018, 2021, 2022
        Experts Exchange Distinguished Expert in Microsoft Office 2022
        Experts Exchange Distinguished Expert in VBA 2022
        Experts Exchange Top Expert VBA 2018 to 2022
        Experts Exchange Top Expert Visual Basic Classic 2012 to 2022