In our little example we have created 2 dynamic tables with which we want to work.

The goal will be to transfer the data entered in the first table into the second table by means of a button, and then continue to update it.

If you have not already done so, you will first need to unlock the developer tools to get the function of the macros. To enable Developer Tools, go to the tab:

“File” – “Options” – “Customize Ribbon”

and put the appropriate hook there.

Then, by default, you’ve enabled your new additional Developer Tools tab in Excel.

See picture: (click to enlarge)

As already said, the goal is to transfer and update data from one table to another via a button.

For this we have to think carefully about our work steps.

We will copy the entries in the first table step by step during the recording, insert them into the second table accordingly, and finally insert a new line to make room for the next entry.

Because we want to create an updating table.

Of course, we would have been able to set a keyboard shortcut to create our macro in this way. But since we like it firstly comfortable, and secondly probably after some time of non-use anyway no one has noted the shortcut, we will use a button for this purpose.

It’s always there, and it just looks fancier.

To do this, right-click on the button, select “Assign Macro” and select the macro from your list (if you have created several macros).

Of course, you can also assign a unique name to the button by right-clicking on “Edit Name”.

See picture: (click to enlarge)

You can now transfer all entries from one list to another at the touch of a button.

As you have seen, the process is far less complicated than it first appeared. Of course, you can use the macro function in Excel to automate significantly more complex processes, which is why you are welcome to be creative at this point.

And always remember: Excel does not bite ;)