In data validation I'm trying to refer to a list in a different sheet but I
didnt work. I have followed the help function in Microsoft but I keep getting
the message that in data validation you cannot refer to a list in a different
workbook.