We help IT Professionals succeed at work.

create the find button for key

ADRIANA P
ADRIANA P asked
on
this question belongs from https://www.experts-exchange.com/questions/29170042/create-find-to-select-key-4NR.html

create the find button  for the others 9 keys as each output sheet
29170042.xlsm
Comment
Watch Question

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

Commented:
Let's assume that I create a total of 10 'KEY' output sheets called 1KEY, 2KEY, etc. Let's also assume that162 occurs once in both the 1KEY and 2KEY columns on the R_DTA sheet. Should there be just one column on output sheet KEY1 and just one column on output sheet KEY2?

Supongamos que creo un total de 10 hojas de salida 'KEY' llamadas 1KEY, 2KEY, etc. Supongamos también que162 ocurre una vez en las columnas 1KEY y 2KEY en la hoja R_DTA. ¿Debería haber solo una columna en la hoja de salida KEY1 y solo una columna en la hoja de salida KEY2?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin

one column for each key

example
key 1 is column L only

================================================
Martin

una columna para cada llave

ejemplo
llave 1 es columna L solamente
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
then one sheet for key
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Try this.
29170129.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin i get this error when i hit find key button
x1x11.PNG
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
In that sub, under "Dim strMsg As String" put "Dim lngLastRow As Long".
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin

i did
but now this is the shows
y1y1.PNG
"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
Corrected.
29170129a.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Great Job !best Expert!
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:

A made a few small corrections. For example the A1 and LAST ROW buttons now work.29170129b.xlsm