We help IT Professionals succeed at work.

# create the find button for key

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

## View Solution Only

"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?
ACCOUNTING ASSISTANT

Commented:
Martin

one column for each key

example
key 1 is column L only

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

ejemplo
llave 1 es columna L solamente
ACCOUNTING ASSISTANT

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

Commented:
Try this.
29170129.xlsm
ACCOUNTING ASSISTANT

Commented:
Martin i get this error when i hit find key button
"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".
ACCOUNTING ASSISTANT

Commented:
Martin

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

Commented:
Great Job !best Expert!
"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