View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ric[_7_] Ric[_7_] is offline
external usenet poster
 
Posts: 15
Default Excel spreadsheet

Hello,
I am attemting to put a value in spreadsheet-Total CS (B6) by
referring to the next spreadsheet over with following formula='VT by
Brand 07-09'!E2. From there go down exactly 6 cells =INDIRECT("'RI by
Brand 07-09'!S"&(ROW()-5)*6-2) and put that value in first spreadsheet
Total CS (B7). I want to continue 6 cells down each time and finish
at B37. What is wrong with my formula (s)????