The attached code works well on what it is intended to do.
Rows enter the Incoming sheet via a web query. Then these rows are sorted by removing duplicates and move to Checked sheet. This is where help is needed.
As Incoming sheet will be updated every 30 minutes or so, eventually after the first, second or even third refresh, the same rows are going to be moved to Checked Sheet again and again.
Is there a way to prevent this from happening.
Thank you in advance!
Bookmarks