I probably should have been more specific now that I think of it. I understand what to do and the logic behind it, I just don't know the syntax. The person who gave me the task doesn't know VBA either I believe. This copy paste thing isn't a one time deal either, the WHOLE macro is. Copying and pasting is just a part of the macro. Also, there are 7+ tabs that will be copied from and at least 1 copy/paste per tab. So if you could, could you give me the syntax by chance? To be even more clear, I need it to paste to a specific row of my choosing, and that row will increment by one after each paste, if that makes sense.