Hi, I saw the code on this link:
https://www.computing.net/answers/o...The code works well. I just need to tweak it so it would paste starting from the 2nd row of sheet 2 onwards
Please help! Thanks :)
message edited by waferstix
Try changing this: Destination:=Sheets(2).Cells(copyRow, 1)to this:
Destination:=Sheets(2).Cells(copyRow + 1, 1)Let us know if that works. If it doesn't, tell us what doesn't work.
How To Post Data or Code ---> Click Here Before Posting Data or VBA Code