I have a rather odd question that I hope someone can help me with.
For this scenario, please assume the following:
There is a named range 'Countries', that contains cells 'A1:A10' on sheet 'Validation Tables'.
There is a cell, B1, on a different sheet, that is using Data Validation to provide...