VBA Find Macro

[Odo]

I have a spreadsheet that has part number (formatted as text) in Column A, Description in Column B and Stock Count in Column C. I would like to search for the part number and have the active cell in column c waiting for the count, ask fr then next part number. Thank you

 

[dave3009]

One method

In the worksheet module for the sheet in question use

Private Sub Worksheet_Change(ByVal Target As Range)
RunParts
End Sub

In a standard module

Sub RunParts()
Dim MyPart As String
Dim LR As Long
Dim i As Long
LR = Range("A" & Rows.Count).End(xlUp).Row
    MyPart = InputBox("Enter Part Number")
    If MyPart = "" Then Exit Sub
    For i = 2 To LR
        If Range("A" & i).Value = MyPart Then Range("C" & i).Activate
    Next i
End Sub

If you'd prefer this just a single macro that can also be achieved

 

[Odo]

Hi Dave3009,

Thanks for helping me.