Excel VBA to Copy Data from one Sheet to Another

Absolute Vs. Relative Excel Macro Recording

VBA to move data from one excel sheet to another

Can the Macro Recorder dynamically find the end of a range?

This is where relative and absolute macro recording come into play.

Each one has their advantages and disadvantages.

In this tutorial I show you how you can use the macro recorder to copy data from one Worksheet to another sheet. In fact we copy the data to the bottom of an existing data set from two different tabs. We also insert a button and assign the macro to it.

Note: This video is part of my upcoming Excel VBA & Excel Macros course called Unlock Excel VBA & Macros which is due to be out in April. To receive your launch discount make sure you register your name here.

In the course we go from basic all the way to advanced. Check out the last 2 minutes of this video to get an overview of the course topics.

Feel free to Download the Workbook HERE.

Free Excel Download

Unlock Excel VBA & Macros Course is here.

Save time. Achieve more.

Over 50 Excel macro examples for download & useful VBA codes you can use for your work.

Redeem your coupon for 75% off below.

Get 75% off the course
Free Ebook


  1. Maxood April 14, 2018 at 12:02 pm - Reply

    Hi, I love your style of teaching and your grasp of knowledge of Excel. I have seen many of your tutorials on Youtube and like them all esp VBA tutorials. You have made complex and rather confusing VBA topic into so simple and easy to understand. Thanks and keep it up..

    • Leila Gharani April 17, 2018 at 12:53 am - Reply

      Thank you for your kind comment. I’m very happy to hear you find the lectures easy to follow :)

Leave A Comment

Share This