Hi all,
Any help on this problem would be greatly appreciated.
So I have a database type workbook which manages loans.
I would like to create a reconciliation report that on a sheet called "RECONCILIATION" that shows all the drawdowns and repayments for the past month so that I can cross reference it with my bank statement.
I have attached a sheet which contains the format of the report.
All of the necessary data is stored on a sheet called "DATA STORAGE". The data is arranged in a massive table it is a named range called DATASTORAGE (D4:EP1003).
All the relevant data for a client is stored in the same row as their name & ID
Column 1 contains the client's name
Column 2 contains the client's ID
Each client is allowed 5 drawdowns & 10 repayments the details of which are located in the following columns of the DATASTORAGE table:
Date Amount
Drawdown 1 88 89
Drawdown 2 91 92
Drawdown 3 94 95
Drawdown 4 97 98
Drawdown 5 100 101
Date Amount
Repayment 1 104 105
Repayment 2 107 108
Repayment 3 110 111
Repayment 4 113 114
Repayment 5 116 117
Repayment 6 119 120
Repayment 7 122 123
Repayment 8 125 126
Repayment 9 128 129
Repayment 10 131 132
It would be ideal if the macro could run when the drop down box (named range: MONTHSELECT) is changed.
And then for the month that is selected, show all the drawdowns in the top section of the attached report format and all the repayments in the lower half of the report.
Any help would be greatly appreciated.
If further information is required to solve this please ask.
Thanks in advance
Adam
Bookmarks