Trasfering data with vba

[Closed]
Report
-
Posts
4
Registration date
Monday October 17, 2016
Status
Member
Last seen
November 2, 2016
-
Hello,
I have sheet1 of data with 2 columns with 26 row
And i want to copy this data to sheet2 but when i copy this data it overwrite the old one and thats my problem
What i need when i copy this data it autofit the first empty row in sheet2 without replacing the old one
I need to add commande button and get the best vba code pls



3 replies


We do not provide turn key solutions. If you were stuck, we could help, but you have to post some code first. I encourage you to RECORD a macro, and see how it WRITES the code, then change the code with variables!

It's kind of fun to do the impossible! -Walter Elias Disney
Posts
4
Registration date
Monday October 17, 2016
Status
Member
Last seen
November 2, 2016
1
Open an excel workbook
Enter some data in Sheet1 at A1:B10
Press Alt+F11 to open VBA Editor
Insert a Module for Insert Menu
Copy the above code and Paste in the code window
Save the file as macro enabled workbook
Press F5 to run it
Posts
4
Registration date
Monday October 17, 2016
Status
Member
Last seen
November 2, 2016
1
Method 1: In this method, we do not required to activate worksheet. We have to mention the source and target range. This is the simple method to copy the data.
Method 2: In this method, we have to activate the worksheet and paste in a range of active worksheet.