Macro to filter exact sum total

[pkk1964]

Hi,

Is it possible to create a macro that can filter a list to leave values that add up to a defined value. eg if the defined value was 50, the macro would attempt to return a list of values that sum up to this total.

Many thanks in anticipation

 

[VoG]

This may help you http://www.tushar-mehta.com/excel/templates/match_values/index.html

 

[pkk1964]

VoG,

Many thanks for that, it looks like it will do the job.