Thank you so much! This works brilliantly. I have looked at the code and confess to being flummoxed! Is it too much to ask for a version of it with an explanation of what each bit does? I might then stand a better chance of being able to adapt it myself for other workbooks. There is just one more thing that I feel I need: is it possible for the code to check if there is already any data in the chosen range before copying? And if so, can it throw up a message checking if the user wants to overwrite the data that is there? You have been really helpful - thanks again!