Loop is overwriting instead of moving down to next empty cell

[okieguy19]

I cannot figure this out. I need some help.

My code is working with respect to finding the right data, but it keeps overwriting itself on each loop through...I need it to copy/paste and then on the next loop, move down one cell...

Please Login or Register  to view this content.

please help.

[Norie]

You never increment NextRowB, NextRowF and NextRowC in the loop, so you are always going to be pasting to the same row.

Either add this just before the Next statements or move the code that finds the next empty row inside the loop.

Please Login or Register  to view this content.