How can I avoid reload of ID's that have been moved from active sheet to archived sheet
I have a sheet in which I'm uploading errors, which then need to be handled by other members.
Those loaded errors are repetitive loaded for 14 days, but when a member is actually telling the error is closed it is moved to an archived sheet.
Due to that move the error is fully reloaded in the error overview on next reload while is shouldn't.
Anyone any idea's on best practice to avoid the reload of those closed errors?