View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] pignataro1@cox.net is offline
external usenet poster
 
Posts: 21
Default What am I missing here???

Good morning all,

Cannot figure out what I am missing here.

This is in cell F6

='VT by Brand 07-09'!S7

This is in cell F7

=INDIRECT("'VT by Brand 07-09'!S"&(ROW()-5)*6)

This should go down 6 rows to S13 on "VT by Brand 07-09 page and
retrieve data but it is 1 row short-What am I missing here???

Thanks