Macro for command button to copy + paste on each click next row from table to another table

[ColdSpirit]

Hey everyone,
hope you are all fine.
I have 2 Tables:
MasterTable
UsadasTable
I need, on each click on command button, to cut values on MasterTable B4/C4/D4 and paste to UsadasTable I4/J4/K4
On the next click, i need cut the values of the next row from MasterTable B5/C5/C5 and paste to UsadasTable I5/J5/K5, then on each click repeat until there is no more data.

Many thanks in advance.
And have a great weekend.

 

[MCLIFTO8]

Hello again,
with the last code, it is not working. When i click the cmd button it just doesn't do anything

I think you are missing something as I tested the code with dummy data on columns E & J.
Check the sheet reference is correct. Then add some break points and run the debugger to watch the variables step by step.

 

[ColdSpirit]

Ok, i tested in a dummy sheet.
i tried to start on the cell E5 and it didnt work.
When i inserted data on cell E1 it worked however it was pasting not on J1 but on J2.

How can i bypass this?

Thank you =)

 

[MCLIFTO8]

As per your screenshots and code provided. You asked for a copy from column E to column J with headers on columns E and J, starting from headers on row 4.

It works within that context, here's a video.

I can't help you anymore on this one, there are plenty of people on this forum much more experienced than me so you will need to seek them out. Goodluck.

ZI

 

[ColdSpirit]

As per your screenshots and code provided. You asked for a copy from column E to column J with headers on columns E and J, starting from headers on row 4.

It works within that context, here's a video.

I can't help you anymore on this one, there are plenty of people on this forum much more experienced than me so you will need to seek them out. Goodluck.
View attachment 79471ZI

Hello again,
I understand now! Thank you for showing graphically!

The problem was the row number I was using!
I tested on row 4, and it worked!
I will modify my layout to accommodate the data from row 4!

Thank you so much! You helped me a lot!