If I remember correctly, this will not work if it is on another sheet, it needs to be on the same sheet. you create teh list and then int eh cell that you want teh drop down you go to Data>Validation and then choose to allow list.
I need to create a dropdown list on a few columns, I seem to have forgotten how to do it. I remember I have to create the entire list on another sheet, but I dont remember the rest of the steps.
Please help, thank you.