See attached workbook sample. I need two separate procedures:
I have a workbook designed to capture product information and which contains two worksheets. Sheet 1 will capture high-level information about the products while Sheet 2 will capture price information about the same products.
Users will begin by entering high-level data on Sheet1 including entering the Part Numbers in column A. Once Sheet 1 is complete users will then begin entering data on Sheet 2. Once again, they need to enter Part numbers on Sheet2 column A. I want to validate the part number(s) they enter on Sheet2 Column A match a Part number previously entered on Sheet1 Column A. If no match is found, I merely want to highlight the cell on Sheet 2 in yellow. For this procedure, there no need for any drop down list on Sheet 2 that forces the user to enter a valid part number.
This procedure is something I plan to use in an Add-In I'm developing. Here I do want to create a drop down list that forces user to enter a valid Part number on Sheet 2/ column A.