I have two sheets. On Sheet1, cell B3 is a value that can be changed based on user input. This value is the vendor code. On Sheet2 is an array of data for every vendor. Vendor name, vendor location, etc. Column B on Sheet2 contains the vendor codes.
What I am looking for is a macro so that Excel takes the vendor code entered in Sheet1 cell B3, then looks for it in column B on Sheet2. Once located, it should the select the entire row that the value appears in.
There will be other things done after that row is selected, but I can take care of that. I just need to get to where the correct row is selected.
Can anyone help?
I appreciate all input on the matter!
What I am looking for is a macro so that Excel takes the vendor code entered in Sheet1 cell B3, then looks for it in column B on Sheet2. Once located, it should the select the entire row that the value appears in.
There will be other things done after that row is selected, but I can take care of that. I just need to get to where the correct row is selected.
Can anyone help?
I appreciate all input on the matter!