Bank Recon

[edwinm]

I'm trying to produce a routine to help with Bank Reconciliation.

I need to be able to input a total and the routine should then show the values in a list that sum to that total (maybe by highlighting the cells). If there is more than one solution it needs to cycle through the possible combinations!

It seems that I need a hero as I'm out of my depth

Edwin

 

[dave3009]

Hi Edwin

Welcome to the board

I'm not sure what you are trying to achieve is it random combinations of numbers to SUM to a given result or is it looking to compare bank statements to your accounting books?

You may need to give a wee bit more info

Dave

 

[dcardno]

There is a post on this at **** Kusleika's "Daily Dose of Excel" blog which also includes a file that finds such combinations

 

[dbooth]

I just asked a similar question to this one.

Peter_SSs gave me these links, the second of which I am now using in my Bank Rec at work.
It doesn't highlite the cells but it does give you all possible combinations by cell number.

http://www.mrexcel.com/pc09.shtml

http://www.mrexcel.com/board2/viewtopic.php?t=46187

Hope they help.

DB

 

[edwinm]

Thank you all for your help.
I have found what I needed from a combination of the links you suggested

Regards
Edwin

 

[binuk]

laughfactory4u: Microsoft Excel Macro for Automatic Bank Reconciliation Statement