I have a macro that copies and pastes data from one sheet to another sheet. This macro was working perfectly fine for awhile. However, now it is cutting off the number of rows that get copied from my "CP" sheet into my "Data" sheet based on how many rows I have in my "Data" sheet.
For example, I have 180,000 rows of data in my "Data" sheet as of now. My "CP" sheet now has 182,000 rows. Only 180,000 rows are being copied from my "CP" sheet but I am needing all the rows to be copied and pasted over.
Here is the macro I am working with:
Sheets("CP").Range("A2:A" & Cells(Rows.Count, "A").End(xlUp).Row).Copy Destination:=Sheets("DATA").Range("C" & Rows.Count).End(xlUp).Offset(1, 0)
What I am assuming is happening is that the macro is counting the number of rows on the "Data" sheet and then pasting that number of rows from the "CP" sheet. However, I don't know what is wrong with it because I need to count the rows so that it pastes the "CP" data below the current data in the "Data" sheet.
Does anyone have any idea of what I need to adjust to get this to work properly?