Search data inside column
 

Just want implement search option in Excel workbook - to search for target
name in rows of the first column.
How to implement this better?

Regards

Search data inside column
 

Would you like the Search to display the row number or select the cell?
--
Gary''s Student - gsnu200751


"SANTANDER" wrote:

Just want implement search option in Excel workbook - to search for target
name in rows of the first column.
How to implement this better?

Regards

Search data inside column
 

"Gary''s Student" wrote in message
...
Would you like the Search to display the row number or select the cell?
--
Gary''s Student - gsnu200751


"SANTANDER" wrote:

Just want implement search option in Excel workbook - to search for
target
name in rows of the first column.
How to implement this better?

Regards

----------
I want that search move me to this row. The rest columns contain the other
relevant info located in the given row.

Search data inside column
 

Sub santander()
Dim s As String
s = Application.InputBox(prompt:="Enter Name to be found: ", Type:=2)
For i = 1 To Cells(Rows.Count, 1).End(xlUp).Row
If s = Cells(i, 1).Value Then
Application.Goto reference:=Cells(i, 1), scroll:=True
Exit Sub
End If
Next
MsgBox (s & " not found")
End Sub

--
Gary''s Student - gsnu200751