+ Reply to Thread
Results 1 to 3 of 3

Macro to compare sheet1 to Mapping and Extract account numbers that do not exisst

  1. #1
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,031

    Macro to compare sheet1 to Mapping and Extract account numbers that do not exisst

    I have sheet1 with account numbers in Col A and Mapping with account numbers in Col B


    I need a macro to compare Sheet1 Col A with Sheet "Mapping" Col A . Where there are account numbers on Sheet1 not on Sheet Mapping, I need these extracted on Sheet ""New Account Numbers"


    It would be appreciated if someone could kindly assist me

  2. #2
    Valued Forum Contributor
    Join Date
    11-04-2018
    Location
    Denpasar
    MS-Off Ver
    Excel 2010
    Posts
    775

    Re: Macro to compare sheet1 to Mapping and Extract account numbers that do not exisst

    Maybe something like this ?
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,031

    Re: Macro to compare sheet1 to Mapping and Extract account numbers that do not exisst

    Thanks for the help. Code works perfectly

+ 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] Macro to extract account numbers
    By Howardc1001 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-30-2021, 11:49 PM
  2. Account & Dept Mapping
    By mvparker79 in forum Excel Formulas & Functions
    Replies: 26
    Last Post: 04-26-2019, 01:41 PM
  3. Need formula to extract account ID, per unique sub-account
    By ierosadopr in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-21-2019, 10:38 AM
  4. Replies: 3
    Last Post: 06-10-2018, 08:34 AM
  5. [SOLVED] Extract Just the Account Numbers
    By moxy7 in forum Excel General
    Replies: 12
    Last Post: 10-30-2013, 12:54 PM
  6. Compare Sheet1 and Sheet 2 and Remove Matching Records from Sheet1
    By MotoDave in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-21-2013, 12:35 PM
  7. [SOLVED] formula needed to search account numbers, sum totals and compare
    By extrudebg in forum Excel General
    Replies: 3
    Last Post: 01-09-2012, 03:10 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