Can someone help me with VBA code that does the following. I will explain what I have been doing manually in the sheet.
will apply conditional formatting to highlight duplicates in column A. Will filter "yes" from column B and then will filter by color of red from A (highlighted ones from conditional formatting) and any resulted rows needs to be deleted. If I found nothing we can leave it as it is.
Sample Data: Blanks in "B" column should be considered as NO.
Once conditional formatting is applied.
Yes in Column "B" and then respective rows of any highlighted cells in column "A" must be removed from the sheet.
the out put will be as below.
will apply conditional formatting to highlight duplicates in column A. Will filter "yes" from column B and then will filter by color of red from A (highlighted ones from conditional formatting) and any resulted rows needs to be deleted. If I found nothing we can leave it as it is.
Sample Data: Blanks in "B" column should be considered as NO.
Column A | Column B |
VBA | Yes |
VBA | No |
VMA | |
VCA | No |
VDA | Yes |
VDA |
Once conditional formatting is applied.
Column A | Column B |
VBA | Yes |
VBA | No |
VMA | |
VCA | No |
VDA | Yes |
VDA |
Yes in Column "B" and then respective rows of any highlighted cells in column "A" must be removed from the sheet.
the out put will be as below.
Column A | Column B |
VBA | No |
VMA | |
VCA | No |
VDA |