View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hervinder Hervinder is offline
external usenet poster
 
Posts: 20
Default Find a sum of a combination of cells to equal a value

I have a maths problem which i am trying to solve with a macro.

I have a list of numberin column A such as

12
14
45
24
85
78
5
33

If i have a value lets say 62 which is the sum of two or more values in the
list i would like the macro to place a formula under the list of values
adding the cells which make up that total.

62 is made of 33+5+24 this would be formula i would want placed under the
list.

Any suggestions?