I am setting up a list for cells. I am using data validation and
picking a named range. I have no issue if the range is in the active
workbook. but i need to use a range from a different workbook. is that
possible? if so how?

Thanks