Macro for "adding" solver "constraints"?

[hansaaa]

Hi, I have a spread sheet, that looks somewhat, like sheet.xlsx.

I want to run a solver, such as II9mIHV.png. However, I would like to have constraints, not oonly for cells F7,G7, etc, but, also, all other cells in that row, up to FQ.


I.e., the constraints included in that sample, are F7<=F5, G7<=G5, and, i want to add, H7<=H5, ... up to FQ7<=FQ5.

I can do this manually, clicking add, and so on, for each column. However, this takes a lot of time, and, is quite redundant.

Can I somehow, easily, record a macro, that does this for me, up to FQ7<=FQ5?

Cheers!

C

[shg]

One constraint: F7:FQ7 <= F5:FQ5

Also, the formula in GG9,

=IF(AND(ISNUMBER(F9),ISNUMBER(G9),ISNUMBER(H9),ISNUMBER(I9),ISNUMBER(J9),ISNUMBER(K9),ISNUMBER(L9),ISNUMBER(M9),ISNUMBER(N9),ISNUMBER(O9),ISNUMBER(P9),ISNUMBER(Q9),ISNUMBER(R9),ISNUMBER(S9),ISNUMBER(T9),ISNUMBER(U9),ISNUMBER(V9),ISNUMBER(W9),ISNUMBER(X9),ISNUMBER(Y9),ISNUMBER(Z9),ISNUMBER(AA9),ISNUMBER(AB9),ISNUMBER(AC9),ISNUMBER(AD9),ISNUMBER(AE9),ISNUMBER(AF9),ISNUMBER(AG9),ISNUMBER(AH9),ISNUMBER(AI9),ISNUMBER(AJ9),ISNUMBER(AK9),ISNUMBER(AL9),ISNUMBER(AM9),ISNUMBER(AN9),ISNUMBER(AO9),ISNUMBER(AP9),ISNUMBER(AQ9),ISNUMBER(AR9),ISNUMBER(AS9),ISNUMBER(AT9),ISNUMBER(AU9),ISNUMBER(AV9),ISNUMBER(AW9),ISNUMBER(AX9),ISNUMBER(AY9),ISNUMBER(AZ9),ISNUMBER(BA9),ISNUMBER(BB9),ISNUMBER(BC9),ISNUMBER(BD9),ISNUMBER(BE9),ISNUMBER(BF9),ISNUMBER(BG9),ISNUMBER(BH9),ISNUMBER(BI9),ISNUMBER(BJ9),ISNUMBER(BK9),ISNUMBER(BL9),ISNUMBER(BM9),ISNUMBER(BN9),ISNUMBER(BO9),ISNUMBER(BP9),ISNUMBER(BQ9),ISNUMBER(BR9),ISNUMBER(BS9),ISNUMBER(BT9),ISNUMBER(BU9),ISNUMBER(BV9),ISNUMBER(BW9),ISNUMBER(BX9),ISNUMBER(BY9),ISNUMBER(BZ9),ISNUMBER(CA9),ISNUMBER(CB9),ISNUMBER(CC9),ISNUMBER(CD9),ISNUMBER(CE9),ISNUMBER(CF9),ISNUMBER(CG9),ISNUMBER(CH9),ISNUMBER(CI9),ISNUMBER(CJ9),ISNUMBER(CK9),ISNUMBER(CL9),ISNUMBER(CM9),ISNUMBER(CN9),ISNUMBER(CO9),ISNUMBER(CP9),ISNUMBER(CQ9),ISNUMBER(CR9),ISNUMBER(CS9),ISNUMBER(CT9),ISNUMBER(CU9),ISNUMBER(CV9),ISNUMBER(CW9),ISNUMBER(CX9),ISNUMBER(CY9),ISNUMBER(CZ9),ISNUMBER(DA9),ISNUMBER(DB9),ISNUMBER(DC9),ISNUMBER(DD9),ISNUMBER(DE9),ISNUMBER(DF9),ISNUMBER(DG9),ISNUMBER(DH9),ISNUMBER(DI9),ISNUMBER(DJ9),ISNUMBER(DK9),ISNUMBER(DL9),ISNUMBER(DM9),ISNUMBER(DN9),ISNUMBER(DO9),ISNUMBER(DP9),ISNUMBER(DQ9),ISNUMBER(DR9),ISNUMBER(DS9),ISNUMBER(DT9),ISNUMBER(DU9),ISNUMBER(DV9),ISNUMBER(DW9),ISNUMBER(DX9),ISNUMBER(DY9),ISNUMBER(DZ9),ISNUMBER(EA9),ISNUMBER(EB9),ISNUMBER(EC9),ISNUMBER(ED9),ISNUMBER(EE9),ISNUMBER(EF9),ISNUMBER(EG9),ISNUMBER(EH9),ISNUMBER(EI9),ISNUMBER(EJ9),ISNUMBER(EK9),ISNUMBER(EL9),ISNUMBER(EM9),ISNUMBER(EN9),ISNUMBER(EO9),ISNUMBER(EP9),ISNUMBER(EQ9),ISNUMBER(ER9),ISNUMBER(ES9),ISNUMBER(ET9),ISNUMBER(EU9),ISNUMBER(EV9),ISNUMBER(EW9),ISNUMBER(EX9),ISNUMBER(EY9),ISNUMBER(EZ9),ISNUMBER(FA9),ISNUMBER(FB9),ISNUMBER(FC9),ISNUMBER(FD9),ISNUMBER(FE9),ISNUMBER(FF9),ISNUMBER(FG9),ISNUMBER(FH9),ISNUMBER(FI9),ISNUMBER(FJ9),ISNUMBER(FK9),ISNUMBER(FL9),ISNUMBER(FM9),ISNUMBER(FN9),ISNUMBER(FO9),ISNUMBER(FP9),ISNUMBER(FQ9)),F9*$F$7+G9*$G$7+H9*$H$7+I9*$I$7+J9*$J$7+K9*$K$7+L9*$L$7+M9*$M$7+N9*$N$7+O9*$O$7+P9*$P$7+Q9*$Q$7+R9*$R$7+S9*$S$7+T9*$T$7+U9*$U$7+V9*$V$7+W9*$W$7+X9*$X$7+Y9*$Y$7+Z9*$Z$7+AA9*$AA$7+AB9*$AB$7+AC9*$AC$7+AD9*$AD$7+AE9*$AE$7+AF9*$AF$7+AG9*$AG$7+AH9*$AH$7+AI9*$AI$7+AJ9*$AJ$7+AK9*$AK$7+AL9*$AL$7+AM9*$AM$7+AN9*$AN$7+AO9*$AO$7+AP9*$AP$7+AQ9*$AQ$7+AR9*$AR$7+AS9*$AS$7+AT9*$AT$7+AU9*$AU$7+AV9*$AV$7+AW9*$AW$7+AX9*$AX$7+AY9*$AY$7+AZ9*$AZ$7+BA9*$BA$7+BB9*$BB$7+BC9*$BC$7+BD9*$BD$7+BE9*$BE$7+BF9*$BF$7+BG9*$BG$7+BH9*$BH$7+BI9*$BI$7+BJ9*$BJ$7+BK9*$BK$7+BL9*$BL$7+BM9*$BM$7+BN9*$BN$7+BO9*$BO$7+BP9*$BP$7+BQ9*$BQ$7+BR9*$BR$7+BS9*$BS$7+BT9*$BT$7+BU9*$BU$7+BV9*$BV$7+BW9*$BW$7+BX9*$BX$7+BY9*$BY$7+BZ9*$BZ$7+CA9*$CA$7+CB9*$CB$7+CC9*$CC$7+CD9*$CD$7+CE9*$CE$7+CF9*$CF$7+CG9*$CG$7+CH9*$CH$7+CI9*$CI$7+CJ9*$CJ$7+CK9*$CK$7+CL9*$CL$7+CM9*$CM$7+CN9*$CN$7+CO9*$CO$7+CP9*$CP$7+CQ9*$CQ$7+CR9*$CR$7+CS9*$CS$7+CT9*$CT$7+CU9*$CU$7+CV9*$CV$7+CW9*$CW$7+CX9*$CX$7+CY9*$CY$7+CZ9*$CZ$7+DA9*$DA$7+DB9*$DB$7+DC9*$DC$7+DD9*$DD$7+DE9*$DE$7+DF9*$DF$7+DG9*$DG$7+DH9*$DH$7+DI9*$DI$7+DJ9*$DJ$7+DK9*$DK$7+DL9*$DL$7+DM9*$DM$7+DN9*$DN$7+DO9*$DO$7+DP9*$DP$7+DQ9*$DQ$7+DR9*$DR$7+DS9*$DS$7+DT9*$DT$7+DU9*$DU$7+DV9*$DV$7+DW9*$DW$7+DX9*$DX$7+DY9*$DY$7+DZ9*$DZ$7+EA9*$EA$7+EB9*$EB$7+EC9*$EC$7+ED9*$ED$7+EE9*$EE$7+EF9*$EF$7+EG9*$EG$7+EH9*$EH$7+EI9*$EI$7+EJ9*$EJ$7+EK9*$EK$7+EL9*$EL$7+EM9*$EM$7+EN9*$EN$7+EO9*$EO$7+EP9*$EP$7+EQ9*$EQ$7+ER9*$ER$7+ES9*$ES$7+ET9*$ET$7+EU9*$EU$7+EV9*$EV$7+EW9*$EW$7+EX9*$EX$7+EY9*$EY$7+EZ9*$EZ$7+FA9*$FA$7+FB9*$FB$7+FC9*$FC$7+FD9*$FD$7+FE9*$FE$7+FF9*$FF$7+FG9*$FG$7+FH9*$FH$7+FI9*$FI$7+FJ9*$FJ$7+FK9*$FK$7+FL9*$FL$7+FM9*$FM$7+FN9*$FN$7+FO9*$FO$7+FP9*$FP$7+FQ9*$FQ$7,"")

Could be simplified to

=IFERROR(SUMPRODUCT(F9:FQ9, $F$7:$FQ$7),"")