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!