Trasfering data with vba

Ask a question Moe - Latest answer on Oct 17, 2016 04:35PM
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 
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
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

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!