Thenewguy is right, you should try to have a look into vba, it makes things so much easier. I use this code in my tradesheets and it works like a charm. I also got a macro that creates a timestamp when the macro pasted the data and it puts in the same time as the time I wanted the macro to copy...