The only catch is that the row will change each time. For example, once I find the row I need, I will copy it, then paste it to the other worksheet. Then, I will go back to the first sheet (where the data was copied from) and go to the next row and copy that data, then repeat the process until a certain cell is blank. All I need to know is how to copy specific rows that will increment (by one). PLEASE USE THE SIMPLEST ANSWER POSSIBLE. My skills in VBA are basically below beginner. I was just told to create a macro in excel, and this is a very important part of it. I have never used VBA before, nor do I intend to as soon as this is done, so I just need a very very very simple answer please



Thank you!

If these rows are all going to the same output worksheet, in the same order they're found on the input worksheet, there is no need (or point) in processing them one at a time; simply specify the range you're interested in, then cut & paste the lot in one go. It's also far more efficient that way.
Perhaps, then, whoever told you to do this should show you how... Besides, if it's a one-time requirement, it would be far quicker to do manually than it would take for anyone to write, test & debug the code - for which access to a workbook containing actual worksheet names & representative data is vital.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

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.

In that case, my previous comments may still apply and, given your confessed lack of vba experience, that seems even more likely. All the same, though, without knowing the scope of the project it's impossible to say for sure.
There really isn't anything generic about the code to do this. I could post some arbitrary code copy for copying & pasting to an active cell, but I doubt that would get you much farther. You would need to provide a whole lot more detail, especially: how the code is to identify the sources to be copied in each case (e.g. you say you have 7+ tabs, so how does the code identify which tabs to copy from and where to find the data on those tabs); the order in which the copy/paste for the different sources to occur; whether the source format is to be retained; whether there are formulae in the sources that are to be retained, or just values; etc.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]