AB33,
Many thanks for the code, its absolutely bang on I have done a fair amount of testing and its works great . I don't fully understand it but ordered a couple of books on vba. inc, one for dummies to get to grips with it. Surprisingly I made a tweak and it worked lol. I have highlighted what I changed in the code as needed to prevent clear contents on columns to the right of QA and added another input sheet and got the data to copy across as well. I added code to the command buttons on each sheet to execute your code, as I couldn't get it to work when tried to insert it to the buttons directly. Is this something me being a novice and not understanding or does the code need to be within the module to be able to work? I have attached a copy of the file with the tiny bit I did so at least it shows some effort on my behalf.
Again thank you for supplying the solution
Cheers
Mark
Bookmarks