I see your problem Kimmy and it looks like you will have to get all your data in one column first and then just hide that or do whatever you want with it, but if you just use autofill from your cells that will go kind of fast. And then use the validation tool it will work.....even if it is a bit...