Moving The Selected Record From One Sheet To Another

Hi everybody,

I have a sheet contains lots of records, some of these records are old and not needed , so I want to transfer them to another sheet in order to go back to them in the future.

I would like you please to provide me with a VBA code works on moving the whole record to the other sheet when I select any cell of that record>

I hope that my question is clear for you,

thank you,