index and offset functions
I am pulling values from another spreadsheet within the same workbook and
need to increment the row munber by 1 when moving the formula down 22 lines.
i.e. =+MON!$D$6 is in I62 and =+MON!D7 will be I84
=+MON!$D$6 =+MON!$E$6 =+TUES!$D$6 =+TUES!$E$6
=+MON!$G$6 =+MON!$H$6 =+TUES!$G$6 =+TUES!$H$6
=+MON!$J$6 =+MON!$K$6 =+TUES!$J$6 =+TUES!$K$6
=+MON!$M$6 =+MON!$N$6 =+TUES!$M$6 =+TUES!$N$6
thanks much!\
Denise
|