Hi All
Having a little trouble with my vba. I am trying to find a value in a list of data dependant on whether that value exists in another list.
I have attached an example of what I am trying to achieve. At the moment I can find a value in List one if I put that value (x) in my code. However, I want the value of (x) to be any value in List 2. If that makes any sense. List 1 contains a set list of values, whereas List 2 will change dependant the user.
The result that I want is that if the any of the contents in list 2 don't exist then a msgbox will tell me.
If somebody could help I would be very grateful.
Bookmarks