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
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