Hi,
I've been looking through a few videos and threads trying to work out a solution. I have managed to write code to move the rows to a new document and auto filter and remove certain rows however I can't work out the following.
I have a list of submission numbers in column B sometimes these submissions return with an error and need resubmiting, I can't work out how to code it so that scans column B and if the submission ID duplicates and in one of the duplicate rows column R = "Success" it deletes both rows?
Perhaps clear in your mind, but please upload the work you have done so far. Then it becomes much easier to diagnose and fix the problem.
Hi,
I've been looking through a few videos and threads trying to work out a solution. I have managed to write code to move the rows to a new document and auto filter and remove certain rows however I can't work out the following https://xender.vip/ https://nox.tips/ .
I have a list of submission numbers in column B sometimes these submissions return with an error and need resubmiting, I can't work out how to code it so that scans column B and if the submission ID duplicates and in one of the duplicate rows column R = "Success" it deletes both rows?
I got this,...
