Unable to Populate data from Tracker sheet to Result Sheet ples provide vb coding

Dear sir,

When i enter LR Number in result sheet then automatically data should paste tracker data related L Number.

Please help.

Thanks
Dattatray Kumbar

You could try this. Right click on tab "Result" then click on "View code"

In the windows that opends paste this code:

Private Sub Worksheet_Change(ByVal Target As Range)
    
    If Not Intersect(Target, Range("C5")) Is Nothing Then
        Run "UpDt"
    End If
End Sub

Then click on "Insert" and click on "Module" in the windows that opends paste this code

Sub UpDt()

Sheets("Result").Range("A8").CurrentRegion.Clear

'Sheets("Tracker").Activate

Sheets("Tarcker").Activate

Range("A4").CurrentRegion.AutoFilter Field:=2, Criteria1:=Sheets("Result").Range("C5")

Range("A4").CurrentRegion.Copy

Sheets("Result").Range("A8").PasteSpecial Paste:=xlPasteValues
Sheets("Result").Range("A8").PasteSpecial Paste:=xlPasteFormats

Application.CutCopyMode = False

ActiveSheet.AutoFilterMode = False

Sheets("Result").Activate

End Sub

Close visual basic windows and save file with .xlsm exstention.

Macro will run whenever you enter a valur in cell C5 (sheet "Result")

Alf