Dear all, I have tried to search on other forums but can't seem to find an answer. Please help for <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym>.
I have some data column A. However, the amount of data varies everytime. In addition, blanks cells may be present in column A as well.
I have some data column B. The amount of data also varies everytime but it's always equal to collum A. In addition, blank cells maybe present as well.
what I need here is to match the values in column A to column B, and if it matches I need to delete the entire row of both collums.
how do I do that in <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym>? A lot of forums talk about a specific value but none on non specific values. Please help.
Thank you in advance!
I have some data column A. However, the amount of data varies everytime. In addition, blanks cells may be present in column A as well.
I have some data column B. The amount of data also varies everytime but it's always equal to collum A. In addition, blank cells maybe present as well.
what I need here is to match the values in column A to column B, and if it matches I need to delete the entire row of both collums.
how do I do that in <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym>? A lot of forums talk about a specific value but none on non specific values. Please help.
Thank you in advance!