Report

Trasfering data with vba

Ask a question Moe - Last answered on Nov 2, 2016 10:56AM
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
See more 
Helpful
+0
moins plus
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!

Add comment
Helpful
+0
moins plus
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
Add comment
Helpful
+0
moins plus
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.
Add comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!