Good day all,

I have a drop down menu in sheet 1 that lists all states, however based on the selected value eg. "QLD" I need to copy the relevant column (this can be anything from say A2:A10) from sheet 2 or "List"? Any advice, thank you all

Marco