Hi, i am a MS office excel user, i wanted a macro for a particular function.

What it exactly needs to do is In a population of say 20, 10 items would
total up to a particular number so the macro should identify those 10 numbers
which would total up to that one particular number. IN other words i would
like to know what items, sum of which would give me a specific total.

It would take at least
=COMBIN(20,10)*0.05/3600
hours to run the macro.
Are you willing to wait that long?