Macro that checks a list, and gives user prompt for action

Originally Posted by jayherring86

Maybe the answer here lies in simplifying the system a little

I don't really get what you mean by simplifying the system. If you can make sure that in both Data and Table Tab, each Customer number + Item code combination only appears once, then it would be much easier to code.