Copy data to excel below existing data

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hi,

I want to copy the data from some other source to the excel. The copied data should get pasted few rows below the existing data.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Since you have not provided much detail, the most versatile and adabtable answer would be find out the last row that was used earlier

lLastRows = Cells(row.count, "A").end(xlup).row
this assumed that max used rows are in column A, change it to suit u

The paste it from after this row, Use macro recorder to assist u