So here is what I am trying to accomplish. I have 5 lists of different words and I want excel to read the lists and populate out all different combinations of the words. The best way to describe it is an example.

If I have 2 lists...

List 1 List 2
Baby Blonde
Child Brunette
Adult

I want excel to then populate a list in rows and columns that looks like this...

Baby Blonde
Baby Brunette
Child Blonde
Child Brunette
Adult Blonde
Adult Brunette

My list has many more options and will total over 8000 combinations so I dont want to do them all by doing a bunch of copy and pastes. If there is an excel function that will do this please let me know what it is.

Otherwise I see a VBA in my future.

Thanks