Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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)???? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel spreadsheet
First of all, your B7 formula is referring to a different sheet than your B6
formula. Your row computation causes B7 to look in E10, which is 8 (instead of 6) rows below E2. The following version works for me: =INDIRECT(ADDRESS((ROW()-5)*6-4,5,,,"VT by Brand 07-09")) Put in B7 and copy down through B37. Hope this helps, Hutch "Ric" wrote: 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)???? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel spreadsheet
On Feb 21, 12:50*pm, Tom Hutchins
wrote: First of all, your B7 formula is referring to a different sheet than your B6 formula. Your row computation causes B7 to look in E10, which is 8 (instead of 6) rows below E2. The following version works for me: =INDIRECT(ADDRESS((ROW()-5)*6-4,5,,,"VT by Brand 07-09")) Put in B7 and copy down through B37. Hope this helps, Hutch "Ric" wrote: 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)????- Hide quoted text - - Show quoted text - Tom, Thank you very much!!!! Works great |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert ms works spreadsheet to excel spreadsheet on pda | Excel Discussion (Misc queries) | |||
conversion of MS Works Spreadsheet to Excel 2002 Spreadsheet | Excel Discussion (Misc queries) | |||
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
Macro to save excel XP spreadsheet to excel 97 spreadsheet format | Excel Programming | |||
How to open another Excel spreadsheet to copy data into current spreadsheet ? | Excel Programming |