I have a list of numbers in column A (A1:A22) that can make up a product.
I have a list of numbers in column E (pasted) that the customer had selected to make up the product, which are the numbers from column A.
Looking for a Macro that looks at E1 then highlights that number in column A, then E2 and highlights that number in column A until it runs into a blank cell in E.
Is it possible when the macro is looking in column E it only looks at the first 11 characters from the left side?
Thanks in advance for any help/suggestions