copy paste value from sheet1 to sheet2 in empty cell only

hi all,

i have a problem with this thing, here is the situation

i have sheet1 name as "data" and has range A1:A5 and i want to assigned a button there with a macro, when we press the button, a macro will run copy paste to sheet2 name as "log" A1:A5,

and if someone press the button again, it will copy to sheet2 range b1:b5 (since we have value already in a1:a5)

is that possible?

thanks for the solution / advice

Try

Please Login or Register  to view this content.

Add a shape to the sheet (Insert tab >> Illustrations >> Shapes) then right click the shape and assign the MoveData macro....