In an Excel spreadsheet, there is a requirement to have a number of options available (say 4). Then alongside these are some list boxes which list the options available.
So, the example of 4 options the first list box will have all 4 options available. Then the next list box will have the three remaining options listed; and so on for the other list boxes.
Is there an easy way to implement this?