compareing 2 columns
 

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?

compareing 2 columns
 

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

Ross

"tomi12619" <tomi12619@laptop wrote in message
...
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?

compareing 2 columns
 

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