Data Validation dependant lists, Excel 2010

apoynz Posts 1 Registration date Monday August 17, 2015 Status Member Last seen August 20, 2015 - Aug 20, 2015 at 05:01 PM

I am in need of a way to create a order form from a table (product list) using Data Validation.
The table is 8 columns and aprox. 5000+ rows.
I need the order form to have 5 columns, 4 use data validation lists to select and sort:
size (col1), load (col2), speed, (col3) then model(s) (col4)
col5 would be the quantity to be entered..

The problem is there is multiples of each and no unique values, there is 600+ sizes and each size could have 3-4 options in each column. I essentially need it to sort like a Pivot Table, with out it being a Pivot Table.

Please help!