Hello everyone
I am new to this group as well as working on excel marcos.
I have made spread sheet where there are two equations (Q1=m1*c*dT and Q2=m2*c*dT) that needs to be balanced (Q1 =Q2) to get such a value of m1 (that utlimately L coming from m1 is same for both m1 and m2). I have made macro (using solver) and its running fine giving correct results when I am only changing m1 but now I want to change both m1 (equation-1) and m2 (in equation 2) both. any help or suggestion will be appreciated.
thanks
I am new to this group as well as working on excel marcos.
I have made spread sheet where there are two equations (Q1=m1*c*dT and Q2=m2*c*dT) that needs to be balanced (Q1 =Q2) to get such a value of m1 (that utlimately L coming from m1 is same for both m1 and m2). I have made macro (using solver) and its running fine giving correct results when I am only changing m1 but now I want to change both m1 (equation-1) and m2 (in equation 2) both. any help or suggestion will be appreciated.
thanks