Attachment 159330

please have a look at the attached file with example...

i can do this with solver but i need to do this in realtime..which is why im trying to have vba code for this...

if u use solver and use the following settings....target cell C6, equal to "min", and by changing cells $E$3:$G$3....u get an answer