+ Reply to Thread
Results 1 to 8 of 8

Macro to extract items not used

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

    Macro to extract items not used

    I have accounts numbers in Col A per the Trial balance that are imported. Col B show the account numbers that have been used


    I would like a macro to compare the account numbers in Col A from row 2 onwards with the account numbers in Col B in and to extract those account numbers in Col A that is not in Col B


    your assistance in this regard is most appreciated
    Attached Files Attached Files

  2. #2
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,286

    Re: Macro to extract items not used

    If I read correctly

    if a not in b then c

    Please Login or Register  to view this content.
    Last edited by nigelog; 10-04-2019 at 08:10 AM.

  3. #3
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Macro to extract items not used

    One way...
    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

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

    Re: Macro to extract items not used

    Thanks for the help guys. code works perfectly

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

    Re: Macro to extract items not used

    No need to loop
    Please Login or Register  to view this content.

  6. #6
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Macro to extract items not used

    Wow, look at that hey...That's how we learn...Tx jindon...
    Thanks for rep Howard...
    Last edited by sintek; 10-04-2019 at 09:04 AM.

  7. #7
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,286

    Re: Macro to extract items not used

    The evolution of code lol...Thanks Howard for rep

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

    Re: Macro to extract items not used

    Thanks for the code Jindon.

+ 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. Extract of line items or entries having unique *6 digit ref* - using Macro VBA
    By Ram_G in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-08-2015, 12:23 AM
  2. [SOLVED] Extract of line items or entries having unique *6 digit ref* - using Macro VBA
    By Ram_G in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-06-2015, 01:42 AM
  3. [SOLVED] Extract of line items or entries having unique *6 digit ref* - using Macro VBA
    By Ram_G in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-06-2015, 12:55 AM
  4. [SOLVED] vlookup extract two items
    By pallet48 in forum Excel General
    Replies: 1
    Last Post: 09-03-2014, 02:30 AM
  5. Extract Items From List
    By MGBush in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-02-2012, 04:45 AM
  6. Excel 2007 : how to extract items from spreadsheet
    By vadaddy in forum Excel General
    Replies: 5
    Last Post: 11-03-2011, 07:55 AM
  7. Extract Unique Items
    By GreenLotus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-15-2007, 09:00 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