+ Reply to Thread
Results 1 to 2 of 2

compare two columns of two tables and extract the the matching number's raws into ano

  1. #1
    Registered User
    Join Date
    12-02-2008
    Location
    India
    Posts
    5

    compare two columns of two tables and extract the the matching number's raws into ano

    i need a macro code to prepare bank reconciliation
    i need to compare two columns of two tables and extract the the matching number's raws into another sheet (column has empty cell can fill up with nil text and can sort column a to z)
    example excel sheets are added
    i want customer ref column (column B) of bank statement compared with column F of bank ledger then extract the matching number raws from both sheet into another sheet leaving a column of space between them
    then do same with credit column of bank statement (column e) and debit column of bank ledger (column G)
    lastly compare and extract debit column of bank statement (column f) and credit column of bank ledger (column H)
    both bank statement excel workbook and bank ledger excel work book added
    please give me code it is year end and i have tedious task of preparing lot of bank reconciliation in my shoulder ,if i get this code it will save lot of time as the last amonts leave in sheet after extraction will be discrepancies
    only extract numbers
    please help me download excel files
    thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,572

    Re: compare two columns of two tables and extract the the matching number's raws into

    If you have a specific question with formulas or VBA please post it. DO NOT post projects to be completed for you.
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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