Hi Pete,

Thanks for your reply.

Yes if you could provide a bit more guidance into that I woukld greatly appreciate.

All of the drop downs need to be in the main sheet with the feed in data in a separate sheet which I will hide. This should allow me to just duplicate the rows and select each element as I need.

I hope this answers your question but please come back to me if you need more.

Thanks, Jon