Excel VBA to Copy Data from one 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.