Profile

Cover photo
Jeff Lenning
Works at Click Consulting
Lives in Sioux Falls, SD
106 followers|189,197 views
AboutPosts

Stream

Jeff Lenning

Shared publicly  - 
1
Paul Young's profile photoStuart Levitt's profile photoJeff Lenning's profile photoAran Poyntz's profile photo
6 comments
 
Hi Jeff,
I need a little direction on Excel Data Validation.
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.
Add a comment...
Story
Tagline
Excel University Author
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Sioux Falls, SD
Previously
Orange County, California - Iowa - California - South Dakota
Work
Occupation
IT Consulting
Employment
  • Click Consulting
    IT Consulting, present
  • Arthur Andersen
  • Gateway
  • Interpore Cross
Basic Information
Gender
Male
Other names
Geoffrey