I am trying to have a button that is linked to a macro show up in
column Y whenever someone clicks in a row.

so if i click anywhere in row 1 this button becomes visible in Row 1
column Y.
then if i click in row 2 the button in row 1 is gone and a button
shows up in row 2 column Y.
and so on.

basically i have a submit button for each row.. and once someone
clicks that button certain cells from that row are copied to another
sheet called "Log". i will keep apending the "Log" sheet with and
include a time stamp so i can see the changes.

if anyone knows of a better way for me to do this please advise.

Thanks so much in advance.