Looking for information on Automating a Reconciliation Report


New Member
Oct 10, 2019
Hi all,

New to this board, and hoping to get some good advice.

My team conducts a lot of data pulls to create reports, and they are all very time consuming. I'm trying to better educate myself in becoming more efficient in excel. One of the reports we do, is a Reconciliation between two systems.

This consists or 3 separate workbooks ( System 1 Data, System 2 Data, Master Reconciliation Template).

Within the Master Template Columns A-H, K, O, R, U, X - are all copy and pasted data from Workbook 1. Columns I, L, P, S, V, Y - are all vlookups to pull in data from workbook 2. Columns J, M, Q, T, V, Z - are the deltas ( if Columns H & I are the same = True, if they are different = False w/ color code).

The business reason for the Recon is to find the differences between the two systems, and update them.

All three of the workbooks are named the same, have default formats, and are saved in the same location each time.

Is there a VBA Code or Macro that could be created, so when workbook 1 and workbook 2 are created and saved in the location with the Master Recon Template. Could I open the Master Recon Template and execute the code to complete the Reconciliation instead of doing the manual manipulation?

Thank you in advance for any advice or information provided.

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Watch MrExcel Video

Forum statistics

Latest member

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...