Yes, that old chestnut....
Excel 2013
Been using this macro for around 7 years on a membership database with no problems whatsoever. Checks data in "current" sheet and adds/changes to corresponding cells in "archive" sheet
Yesterday as usual added a couple of new members to "current" ran macro...