But it uses values that are in other worksheets - If you look at my attachment I use lists which use text values directly and not from a worksheet. I'm wondering how to make a secondary/sub list dependant on each value selected
so say if text value "A" is selected in list 1 then this only allows the list for "A" to be available for list 2 in its corresponding cell (the next one along)