+ Reply to Thread
Results 1 to 6 of 6

Unmatched coparing two Columns Tab1 with two Columns Tab2

  1. #1
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Unmatched coparing two Columns Tab1 with two Columns Tab2

    Hi.
    The code below was developed by tigeravatar, i try adapt to use only two sheets, but i need compare two columns (concatenated) of "Orig" tab with two columns (concatenated) tab "Result"

    costume 2712 is different costume 27diff then copy this line to Result tab.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    "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.

  2. #2
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Unmatched coparing two Columns Tab1 with two Columns Tab2

    Hi anyone.

    Someone understand my explanation?

    Thanks

  3. #3
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Unmatched coparing two Columns Tab1 with two Columns Tab2

    Hi
    i have Cross-Post in:
    http://forum.chandoo.org/threads/unm...ns-tab2.22178/

    Thank you!!

  4. #4
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Unmatched coparing two Columns Tab1 with two Columns Tab2

    Hi

    Someone have idea how to fix it?

    Thanks

  5. #5
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,525

    Re: Unmatched coparing two Columns Tab1 with two Columns Tab2

    Not really clear the logic though...
    This is how I intepreted the problem.
    Please Login or Register  to view this content.

  6. #6
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Unmatched coparing two Columns Tab1 with two Columns Tab2

    Hi jindon, your brilhant and complex solution save me again!

    I try click in star, but say
    You must spread some Reputation around before giving it to jindon again.
    Thank you very much!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help!!! how can i copy contents from Tab2 into Tab1 using a same cell comparison
    By merQrey in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-30-2014, 06:22 AM
  2. [SOLVED] Insert rows last row Tab1 - Tab2 last line
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-24-2014, 03:41 PM
  3. [SOLVED] Printing tab1 + tab2 as same print job via VBA
    By bigmantitus in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-01-2013, 07:47 AM
  4. Replies: 6
    Last Post: 10-04-2011, 08:48 AM
  5. Replies: 9
    Last Post: 06-09-2011, 10:24 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1