• 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.

Code to delete entire row

Pasadu

Member
Please, I need a code whereby when "CLEARED" appears in cell R13, the entire R row should be deleted. When there is no indication of cleared, the row should not be deleted. Thank You
 

vletm

Excel Ninja
Pasadu
How do "CLEARED" appears in cell R13 - by manual input or by formula or how?
Which row should be deleted? ... Can You give clear example of row's number?
 

Pasadu

Member
Pasadu
How do "CLEARED" appears in cell R13 - by manual input or by formula or how?
Which row should be deleted? ... Can You give clear example of row's number?
CLEARED is by manual input.
Every row that has cleared in column A should be deleted entirely. And the cells or rows below it should be moved upwards when deleted
Thank You.
 
Top