I've done some searching and I'm part way to my answer but getting a bit stuck.
Essentially I have a combo box to select an option e.g. N, F, FX, FY. On another sheet I have an array with numbers referring to these items (N=1, F=2, Fx=3 etc) and data below these in a column that I need to return as an array. This array feeds in as the range for the next combo box - e.g. select N in first box, second box finds column 1 and uses that column except the header as its data range.
The attached spreadsheet has my efforts so far. I've managed to return the first cell in the column but I need the rest below it too.
I know this should be relatively simple but I'm tearing my hair out. Any help would be much appreciated.
Bookmarks