+ Reply to Thread
Results 1 to 1 of 1

Unique between 2 columns Different Sheet and exist/not exists by split key

  1. #1
    Valued Forum Contributor
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,269

    Unique between 2 columns Different Sheet and exist/not exists by split key

    i have sheets("DATA_LAMA") and sheets("DATA_BARU")
    i want to compare 2 columns
    if in sheets("DATA_BARU") IN COL(43) HAS exists with sheets("DATA_LAMA").COL(43) AND IF in sheets("DATA_BARU") COL (7) NOT EXISTS WITH SHEETS("DATA_LAMA").COL(7)
    I WANT COPY range SHEETS("DATA_BARU") TO SHEETS("Resume")
    i use dictionary to save range in sheets("DATA_LAMA")
    this is my coding please every body help me
    Please Login or Register  to view this content.
    Attached Images Attached Images
    Last edited by daboho; 01-24-2018 at 08:24 AM.

+ 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. [SOLVED] vba split data in respective columns based on unique list sheet
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-29-2017, 02:40 PM
  2. VBA to split unique values from 2 sheet end with formula
    By johnlara in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-15-2016, 11:03 AM
  3. Replies: 5
    Last Post: 07-27-2015, 04:27 PM
  4. Split Data Unique Value From 2 Sheet of A column and Move to 2 Sheet with Splited Values
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-21-2013, 04:21 AM
  5. Replies: 2
    Last Post: 01-21-2013, 12:07 AM
  6. Macro to Replace Row if Exists or copy to new row if doesnt exist
    By jgibs in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-15-2012, 01:23 PM
  7. Macro to determine if log file exists or doesnt exist
    By fcomino in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-19-2010, 08:41 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1