Results 1 to 6 of 6
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    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. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: COMPARE AND DELETE LINE (2000)

    second option. Tks

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    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. #5
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    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
  •