Search data inside column

  • Thread starter Thread starter SANTANDER
  • Start date Start date
S

SANTANDER

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
 
Would you like the Search to display the row number or select the cell?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

lastrow function help 6
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
find function not working with merged cells 2
Import multiple workbooks to current workbook in specified row number 0
Search Target <= in Col. "B" to return Date in Col. "A" 1
Search for empty cells and move cells next to 10
Marking found records in Workbook A from Target List in Workbook B 1
Create if partial match then copy and paste data from one cell to another 1

Back
Top