Data Validation dependant lists, Excel 2010

Closed
Report
Posts
1
Registration date
Monday August 17, 2015
Status
Member
Last seen
August 20, 2015
-
Hello,

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!