Hi,
I am trying to set up a spreadsheet with linked dynamic drop down lists, based on a table.
Using the OFFSET function, I have managed to get this to work if the table is on the SAME sheet at the drop down lists. But I want to be able to put the drop down lists onto a different sheet, so that I can lock and hide the table.
Any idea how ?

I don't want to use the 'name based on the previous column' idea, as the table is large and will change weekly.

Also, related issue, the drop downs show all values, even duplicates, which I would like to get rid of.
Any idea how ?