Excel finding and copying

You could try a macro. Something like

Sub HighlightRow()
mynum = Application.InputBox("Enter barcode number")
On Error GoTo 1:

Columns("A:A").Select
Selection.Find(What:=mynum, After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False).Activate
ActiveCell.Select
Selection.EntireRow.Select
1:
MsgBox "Number not found."
End Sub

You'd need to specify the relevant column instead of A:A.

Rgds/Happy Easter,
Andy

Rollin,

>> What is the ultimate goal of highlighting these records? ...
>> ... why not just use an autofilter ... ?

Could be a fair point given the title of the post, although you'd have to AutoFilter repeatedly for each record you wanted. Even with Custom AutoFilter, you'd be limited to fetching 2 records at a time.

(Data -- Filter -- ) Advanced Filter might be worth a look. You'd just set up the "barcodes to fetch" criteria list first, as per the attached.

NB - to fetch the records straight to a different sheet, the Advanced Filter process must be initiated from that sheet.

Rgds/Happy Easter,
Andy