Thanks TMS,

Unfortunately that didnt work. When I altered the details to match the cells the data should pull from i get "You may not use reference operators (such as unions, intersections, and ranges) or array constants for data validation criteria" error message