
New Member

May 11, 2022

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?


Trusted Members
Moderators
Power BI

January 31, 2022


New Member

May 11, 2022

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,...
1 Guest(s)
