I'm trying to get predictive text to work within the drop down lists I've created for cells A4-A17500 on Collection worksheet. Is there a way to do this? I was told Combo box, but it looks like I would need to make a new combo box for each cell. is that correct??

This is what I have so far:
AutoMTGpiceguide


I had to post it there because its too big to upload as excel and the forums was giving me a database error when I tried to upload as .zip.

Any feedback on how to approve formulas or the layout would be great too :o)