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
Bookmarks