View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
denise denise is offline
external usenet poster
 
Posts: 112
Default 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