Copy & Paste from Sheet1 to Sheet2

Good morning!

Can somebody solve this problem for me ? I have the code but is missing something. I want from everytime i use the macro button, the new data to paste it under the previous one.. I mean if data is on A1, the next one to be in A2, A3, etc...

"Worksheets("Sheet2").Range("A1").Value = Worksheets("Sheet1").Range("A1").Value"

This code only replace the previous one.. I want to keep it the previous and the new data to go on A2, A3, etc...

Thank you and have a nice day!

Hello Spikyd,

Try the code as follows:-

Please Login or Register  to view this content.

I am assuming that you do not have a heading in Sheet2, A1.
I am also assuming that you are only ever transferring the value from Sheet1, A1.

I hope that this helps.

Cheerio,
vcoolio.

Object required... Error 424
I'm using MO 2016

Hi Spikyd,

I would say that you are getting the error on this line:-

Please Login or Register  to view this content.

so change it to:-

Please Login or Register  to view this content.

which should match the rest of your code.

Cheerio,
vcoolio.

Is working now! Thank you very much!

You're welcome Spikyd.
I'm glad that I was able to help.

Cheerio,
vcoolio.