Copy from one worksheet, paste into next empty row on other worksheet, for all marked rows

[ftwobtwo]

In “Original 1” information is entered into rows, then each row is marked with an “D” or “C” in column A. The code below is a macro that runs when a button is clicked. It is supposed to look in column A and any rows marked with a C need to be copied and then pasted into worksheet “Data.” If there are 5 rows total with 3 marked with a C then those 3 should be copy and pasted over to the Data worksheet. I do not understand why but I believe that instead of pasting into the next empty row in “Data” so you could see all 3 rows that were marked with a C, it is pasting into the same row each time so that only the last row that was pasted is visible.

Please Login or Register  to view this content.

[AB33]

Please Login or Register  to view this content.

OR

Please Login or Register  to view this content.