# Thread: COMPARE AND DELETE LINE (2000)

1. ## COMPARE AND DELETE LINE (2000)

I have SHEET1 and SHEET2 its contain many data in the range A3:R in the column M (strat from M3) of all sheets is present a string.
My problem is to compare the string in the colum M (start from M3) if the same string is present in SHEET1 and in SHEET2 delete the line in every sheets and copy the line deleted in the SHEET3 ad in the sheet3 the all line finded.

2. ## Re: COMPARE AND DELETE LINE (2000)

Do you want to compare cells in the same row, that is compare Sheet1!M3 with Sheet2!M3, then compare Sheet1!M4 with Sheet2!M4, etcetera?

Or do you want to compare Sheet1!M3 with all cells in Sheet2!M3:M1000, then compare Sheet1!M4 with all cells in Sheet2!M3:M1000 etcetera?

3. ## Re: COMPARE AND DELETE LINE (2000)

second option. Tks

4. ## Re: COMPARE AND DELETE LINE (2000)

1. What should be done if there are multiple matches? For example, if Sheet1!M6 equals Sheet2!M11 and also Sheet2!M35? Or are multiple matches impossible?

2. If a match is found, which row should be copied to Sheet3? The row from Sheet1 or the row from Sheet2?

5. ## Re: COMPARE AND DELETE LINE (2000)

1. What should be done if there are multiple matches? For example, if Sheet1!M6 equals Sheet2!M11 and also Sheet2!M35? Or are multiple matches impossible? Is possible (naturally delete, after the copy in the sheet3, all line finded in Sheet1 and Sheet2)

2. If a match is found, which row should be copied to Sheet3? The row from Sheet1 or the row from Sheet2?

The row from Sheet1

6. ## Re: COMPARE AND DELETE LINE (2000)

Is this a "one-time conversion" as some type of reorganization (if so I would suggest a manual approach using formulas and filtering)

Or is this type of thing a "routine" or a periodic operation, in which case I would suggest a VB routine.

Steve

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•