Hey,
I am working on building a reconciliation for my company's mortgage accounting. The mortgage division is growing fast and soon there will be far to much data to reconcile manually.
I have been able to produce a solid excel 2010 worksheet for the GL data and the "Bank" data. The data has been formatted the same from both sources. (Shown Below)
Now I need to write a Macro that will compare the GL and Bank transactions against each other for two or more unique identifiers, highlight the transactions that net to zero, and move the transactions that net to another worksheet.
My VBA knowledge is low and I have been looking to many sources but can't seem to get any formulas to work. Can anyone see a formula that would work by looking at this problem I am working on. Thank you for your help and time.
Trx Date Account Account Description Debit Credit DR (CR) Description Loan Number (Unique Identifier) 3/5/2015 GL Mortgage - Loans held for sale 128,000.00 0.00 128,000.00 Mar 2015 Mortgage Funding 115000080 3/5/2015 Bank - 0 0 -128,000.00 *borrower name 115000080 3/12/2015 GL Mortgage - Loans held for sale 0.00 -128,000.00 -128,000.00 Mar 2015 Mortgage Sales 115000080 3/12/2015 Bank - 0 0 128,000.00 *borrower name 115000080
Bookmarks