B
ba
Hello,
I am using Microsoft Access/VB code to create an Excel file. The file
is then sent to an outside agency for some data updates.
I would like to add a 'Total Column' which calculates the sum of data
in certain columns in the row.
I can have a formula to do this for me.
So far so good.
The problem is the outside agency can add rows anywhere (begin/middle/
end..) in the spreadsheet and this messes up the formula since the
formula seems to refer to the original or the source cell - not the
current row.
This seems like a simple task but I am not able to come up with the
formula to do this.
In other words, I need the formula to refer to current row in every
row.
I would appreciate any help/suggestions.
Office 2003 environment.
Thank you in advance.
Bharathi.
I am using Microsoft Access/VB code to create an Excel file. The file
is then sent to an outside agency for some data updates.
I would like to add a 'Total Column' which calculates the sum of data
in certain columns in the row.
I can have a formula to do this for me.
So far so good.
The problem is the outside agency can add rows anywhere (begin/middle/
end..) in the spreadsheet and this messes up the formula since the
formula seems to refer to the original or the source cell - not the
current row.
This seems like a simple task but I am not able to come up with the
formula to do this.
In other words, I need the formula to refer to current row in every
row.
I would appreciate any help/suggestions.
Office 2003 environment.
Thank you in advance.
Bharathi.