I'm trying to create a search for it will search the sheet and display information in separate area.
This is what i have but it's not pulling any info.
ub Searchdata()
Dim Lastrow As Long
Dim count As Integer
Lastrow = Sheets("Raw Data").Cells(Rows.count, 2).End(xlUp).Row
For X = 2 To Lastrow...