Hello! Thanks for your reply. Although this article refers to extracting data from data validation lists, not how to create dynamic data validation lists so won't work for me.