Solver Add-in issues

I have excel 2013 and I just recently installed the solver add in. I can now see it in my data tab on the excel sheet that I'm working on. I have two sheets uploaded at the same time. They are actually sheets with pre-loaded data. when I click on box labeled "send to multi-lineup optimizer" i get a "run time error 9" subscript out of range. I need help please thanks.