Copy row to another sheet, on dynamically built button that is placed in the "R" column

[stevensoldan]

I am a total newbie with code, but I would presume the "pseudocode" of this would be as such :

a=button(gui)

for i=i++
print a in column r

(button function)
on click of a, get row a is present in
cut row from sheet 1, paste in sheet 2

(sheet function)
on creation of new row from microsoft form, create "a" for said row

Any help on translating this to code that can be used for excel 365 would be GREATLY appreciated. God bless you guys!

 

[stevensoldan]

I dont know how to alter existing post, but here is an example visualization showing what I am looking for