I have references in Col B, Branch in Col C and Values in Col D
where the Reference is the Same in Col B and branch contains PL and statement and the statement Value is Zero , then then rows containing both the references are to be deleted
See link to sample data below , where I have indicated in red those rows to be deleted
It would be appreciated if someone would kindly provide me with code to do this
Have also posted on macro to Delete Rows where Ref is the Same
where the Reference is the Same in Col B and branch contains PL and statement and the statement Value is Zero , then then rows containing both the references are to be deleted
See link to sample data below , where I have indicated in red those rows to be deleted
It would be appreciated if someone would kindly provide me with code to do this
Dropbox - File Deleted - Simplify your life
www.dropbox.com
Have also posted on macro to Delete Rows where Ref is the Same