Posted by WendyData Validation>Allow>ListUnder source put the range of the listOnce it works, copy down ...