Search named range for multiple matches to critera and return date & values

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

could you post a workbook including the database sheet to be able to test the code on it..
remove any sensitive information from the sheet.
one more question, are the rows in the report template enough to contain all the data or we may need to expand it with code?

HI mohd9876,

Thanks for your reply, I have attached a workbook with the sheet DATA STORAGE, which has the exact same layout as what is in my current workbook. If it works in here I figure I will be able to transpose it into my other workbook.

The rows in the template are currently enough, however in the future they may not be, is it easy enough to extend each table if there are too many results?

Thanks again

can anyone help please?