| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
What am I missing here???
if you're in F7, ROW() returns 7 which puts you in cell S12
" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Missing MB | Excel Discussion (Misc queries) | |||
| Missing Ref | Excel Programming | |||
| Who is missing ? | Excel Discussion (Misc queries) | |||
| Toolbars Missing, And option to Add Missing | Excel Discussion (Misc queries) | |||
| On Error? Creates 1 missing worksheet then never detects any other missing worksheets | Excel Programming | |||
Linear Mode
