Copy data from sheet1 to the end of row with data in sheet2

[ewong]

Hi,

I have this code below that i want to modify. What this code does is basically copying data from sheet "FRP" to sheet "Sheet2".

The data from "FRP" will be pasted at the end of data in "Sheet2" (e.g. if "Sheet2" has data until row 2000, data from Sheet "FRP" will begin pasted down in row 2001)

The problem with this code is with the one that I highlighted blue. Because of the blue colored code, the data will be copy-pasted in row A1528 while "Sheet2" might contain data until row 2100, 2200, 3000, 4000, and so forth.

Is there anyway to modify this so that data from "FRP" will start copied down to the end of data in "Sheet2"?

Thanks!

Please Login or Register  to view this content.

[arlu1201]

Try this

Please Login or Register  to view this content.

Change the column X to whatever is the last column in your file.

[ewong]

Works perfectly! Thanks!

[arlu1201]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

I will do it for you this time.