In Sheet 1 , I have button , if you press that button . user-form will pop-out Ask you for the Material ID . You need to type (Example : 5DJ800.LAB1.99999C)
It will go to sheet 2 which have whole set data . they will find that material ,copy the whole row and paste on to sheet 3.
How to do that in VBA .? Pls help.Thank you!
Bookmarks