• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

vba to delete entire row IF column F is duplicate AND column W is blank

J

J.Steik

New Member
Hello there - I am having a difficult time with this - I am trying to run a macro that will go down the worksheet and delete the entire row based on multiple criteria: only if F is a duplicate and W is blank - can anyone help me on this? I would rather not use the advanced filter options as this list changes all the time, isn't there a simple way of doing this with VBA?

Thank you so much in advance! :)
 
Here is a basic example - I had thought I could move all the columns to the left but that would maybe just be an extra step that would slow the process (?)
 

Attachments

You must log in or register to reply here.
Back
Top