Double click and jump to another sheet with the same data

[feni1388]

Hello..

I need help with macro code.
I have several sheets but the main Master sheet is where everyone put data to check the result.
So within Range D6 to D21, anyone can enter item code.
I want to make it when someone enter an item code and double click it, it will jump to another sheet that has the same item code with its information.

Please help...

Thank you

 

[feni1388]

Wow... just adding that one line.
Thank you so much. It's really perfect now.

 

[Peter_SSs]

Good news!
Thanks for the confirmation.