Pointing to cells i cells back, thus returning contents

[Mikexcel]

I am working on an excel template. I want to eventually add columns BEFORE my cumulative column. I want to set it up so that my cumulative column updates certain text automatically after I insert columns. Basically, I want to know if there is a way to point to cells i places away from the cells that are calling the function, and are getting a return. Here is an example of what I am trying to do: I have a cumulative colunm that iteratively says June - August. When I insert extra columns before the cumulative column, I want this cell that says June - August, to say June - September automatically. Since I will update the cell that is say i=3 places before the cumulative cell and populate it with the text September. Programatically, this is simply done with a for loop, but it seems that excel provides no for loop function. A for loop would do it this way (psuedo code):

CONST CELLS_AWAY = 3;//or whatever
for (int i=1;i<=CELLS_AWAY; i++){
if (cell.contents != " ")
return cell.contents;
break;
}
This message was edited by Mikexcel on 2002-09-16 11:33

 

[Chris Davison]

Welcome to the BOard Michael,

not sure what's up....

you can reply again with a full excel problem : just hit "reply" and type away

lots of people here to help out so go for it

 

[Mikexcel]

sorry - i updated my original post. my mistake - please read the following update:

I am working on an excel template. I want to eventually add columns BEFORE my cumulative column. I want to set it up so that my cumulative column updates certain text automatically after I insert columns. Basically, I want to know if there is a way to point to cells i places away from the cells that are calling the function, and are getting a return. Here is an example of what I am trying to do: I have a cumulative colunm that iteratively says June - August. When I insert extra columns before the cumulative column, I want this cell that says June - August, to say June - September automatically. Since I will update the cell that is say i=3 places before the cumulative cell and populate it with the text September. Programatically, this is simply done with a for loop, but it seems that excel provides no for loop function. A for loop would do it this way (psuedo code):

CONST CELLS_AWAY = 3;//or whatever
for (int i=1;i<=CELLS_AWAY; i++){
if (cell.contents != " ")
return cell.contents;
break;
}