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

[thermax1829]

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

[Alf]

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

In the windows that opends paste this code:

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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

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

Alf