Hi there,
I have a sheet with 6 columns and x number of rows, each row makes up a unique sequence (Sequences are horizontal).
Some of the cells are the same as other rows but the end result is always unique.
What im trying to do is use dependant drop down boxes on another sheet to act as validation.
The idea is you use the 6 dependant drop down boxes, so that the end result is one of the unique sequences from the other sheet.
Ive been down the route of named ranges but it doesnt seem to cater for what I am attempting to do.
Im capable with both excel and vba but not sure how to address this.
Thanks