Hi
I would like to compare 2 columns values. the "+1" is still value. For example there are 1406 in column A and 14061 in column B in this case the whole row should be deleted from the workbook.

Is there a way to do it with a macro?

Could you repeat the question? It's not clear what you're asking for.

Ross

"tomi12619" <tomi12619@laptop> wrote in message
news:(E-Mail Removed)...
Hi
I would like to compare 2 columns values. the "+1" is still value. For
example there are 1406 in column A and 14061 in column B in this case the
whole row should be deleted from the workbook.

Is there a way to do it with a macro?

There are IDs on column A like 1406 or 1412. In column B, there are other values made from the IDs with +1 prefix, like 14061 or 14121. These are logically equal. sometimes in column B there are other numbers.

I would like to clean the table with deleteing the rows containing the "A=1406 = B=14061" values.

> Could you repeat the question? It's not clear what you're asking for.
>
> Ross
>
> "tomi12619" <tomi12619@laptop> wrote in message
> news:(E-Mail Removed)...
> Hi
> I would like to compare 2 columns values. the "+1" is still value. For
> example there are 1406 in column A and 14061 in column B in this case the
> whole row should be deleted from the workbook.
>
> Is there a way to do it with a macro?