I have a spreadsheet that has a list of patients and I need to move the row
when there is an end date entered to an archive sheet. I want the users to
be able to do his automatically by clicking a button or whatever. I have
tried various codes and none seem to wokr.

PS The worksheet has protected cells

Any help would be appreciated