Good Day All
I have some code from @RonDeBruin that is adapted to work for my specific purposes, however i do not know how to make it loop through the rows and increment the ranges each time the criteria is met.
Unfortunately my file is too big to upload,but here is the details and the code.
The criteria is "YES" in Column O
So, each time "Yes" is found in Column O, The highlighted sections in the code needs to increment to the row number corresponding where the "YES" was found.
Each time "Yes" is found needs to produce a new mail.
i.e if "Yes" Is found in Row7 then this
must change to thisPlease Login or Register to view this content.
Please Login or Register to view this content.
Thanks in advance for any help.Please Login or Register to view this content.
Bookmarks