+ Reply to Thread
Results 1 to 6 of 6

Criteria One Sheet Delete duplicates in Two Diffenrents Sheets

  1. 07-17-2014, 12:25 PM #1
    marreco
    marreco is offline
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Criteria One Sheet Delete duplicates in Two Diffenrents Sheets

    Hi.

    How delete duplicate in column A Sheets("Dest1" and "Dest2"), but criteria is in Sheets("Criteria") column A?

    Sheets("Dest1")
    CODIGO PRIORIDADE LOJA CLIENTE ENDEREÇO BAIRRO CEP CIDADE CONTATO TELEFONE ENTRADA DO PEDIDO
    T1-1 BAIXA STA ROSA TESTE 5 AV. de Pinedo,693 Socorro 04764-005 São Paulo João 5687-8911 20/06/2014 16:49:69
    T1-3 BAIXA STA ROSA TESTE 3 AV. de Pinedo,691 Socorro 04764-003 São Paulo João 5687-8909 20/06/2014 16:49:67
    T1-2 BAIXA STA ROSA TESTE 4 AV. de Pinedo,692 Socorro 04764-004 São Paulo João 5687-8910 20/06/2014 16:49:68
    T2-1 BAIXA STA ROSA TESTE 3 AV. de Pinedo,691 Socorro 04764-003 São Paulo João 5687-8909 20/06/2014 16:49:67
    T2-3 BAIXA STA ROSA TESTE 3 AV. de Pinedo,691 Socorro 04764-003 São Paulo João 5687-8909 20/06/2014 16:49:67
    T2-4 BAIXA STA ROSA TESTE 4 AV. de Pinedo,692 Socorro 04764-004 São Paulo João 5687-8910 20/06/2014 16:49:68
    T2-2 BAIXA STA ROSA TESTE 4 AV. de Pinedo,692 Socorro 04764-004 São Paulo João 5687-8910 20/06/2014 16:49:68
    Sheets("Dest2")
    CODIGO QUANTIDADE MATERIAIS STATUS
    T2-4 10 OX 10 MT AGUARDANDO
    T2-2 100 OX 10 MT AGUARDANDO
    T2-1 101 OX 10 MT AGUARDANDO
    T1-1 101 OX 10 MT AGUARDANDO
    T1-1 101 OX 10 MT AGUARDANDO
    T1-2 101 OX 10 MT AGUARDANDO
    T1-2 101 OX 10 MT AGUARDANDO
    T2-4 10 OX 10 MT AGUARDANDO
    T2-2 100 OX 10 MT AGUARDANDO
    T2-1 101 OX 10 MT AGUARDANDO
    T1-1 101 OX 10 MT AGUARDANDO
    T1-1 101 OX 10 MT AGUARDANDO
    T1-2 101 OX 10 MT AGUARDANDO
    T1-2 101 OX 10 MT AGUARDANDO
    Sheets("Criteria")
    CODIGO
    T1-1 '<-My criteria
    T1-2 'Mycriteria
    How delete duplicate in Sheets("Dest1" and "Dest2") based criteria in Sheets("Criteria").columnA ?
    Thank
    Last edited by marreco; 07-17-2014 at 12:29 PM.
    "No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.

    If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
    Reply With QuoteRegister To Reply
  2. 07-17-2014, 03:09 PM #2
    Charles
    Charles is offline
    Valued Forum Contributor Charles's Avatar
    Join Date
    02-10-2004
    Location
    Biloxi
    MS-Off Ver
    Windows 7, Excel 2003,2007 & Mac2011
    Posts
    845

    Re: Criteria One Sheet Delete duplicates in Two Diffenrents Sheets

    Hi,

    Not fully tested. You will need to change the "Sheet" names.

    Please Login or Register  to view this content.
    Charles

    There are other ways to do this, this is but 1 !
    Be Sure you thank those who helped.
    IF YOU'RE SATISFIED BY ANY MEMBERS RESPONSE TO YOUR ISSUE PLEASE USE THE STAR ICON AT THE BOTTOM LEFT OF THE POST UNDER THEIR NAME.
    Reply With QuoteRegister To Reply
  3. 07-17-2014, 03:20 PM #3
    marreco
    marreco is offline
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Criteria One Sheet Delete duplicates in Two Diffenrents Sheets

    Hi, thanks

    look my file
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 07-17-2014, 03:25 PM #4
    Charles
    Charles is offline
    Valued Forum Contributor Charles's Avatar
    Join Date
    02-10-2004
    Location
    Biloxi
    MS-Off Ver
    Windows 7, Excel 2003,2007 & Mac2011
    Posts
    845

    Re: Criteria One Sheet Delete duplicates in Two Diffenrents Sheets

    Hi,

    I have your file what is it that you want me too look at?

    Hi. Modified code to your format.
    Please Login or Register  to view this content.
    Last edited by Charles; 07-17-2014 at 03:37 PM. Reason: added updated code
    Reply With QuoteRegister To Reply
  5. 07-17-2014, 03:36 PM #5
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Criteria One Sheet Delete duplicates in Two Diffenrents Sheets

    You do not have T2 as in sheet criteria.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 07-17-2014, 04:24 PM #6
    marreco
    marreco is offline
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Criteria One Sheet Delete duplicates in Two Diffenrents Sheets

    hi my frieds, very very good!!!!

    thank you very much!!!!!!!!!!!!!!!!!!!!!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. compare 2 sheets and then delete duplicates
    By masterkey in forum Excel General
    Replies: 2
    Last Post: 03-04-2013, 06:35 AM
  2. [SOLVED] Delete duplicates based on criteria
    By chrism_cfu in forum Excel General
    Replies: 6
    Last Post: 12-07-2012, 08:52 AM
  3. Move Names and addresses from over 3000 sheets to one sheet so I can delete duplicates
    By JERRY GENNINGS in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-09-2012, 03:12 AM
  4. using macro to delete duplicates on two sheets
    By cjm7411 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-31-2011, 10:08 AM
  5. Cannot delete the duplicates on date criteria
    By kwik98 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-15-2010, 02:58 AM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1