Hi VcDeveloper,
Word's cell addressing doesn't directly support relative references. There is a workaround, however. To see how to do this and a
wide range of calculations in Word, check out my Microsoft Word Field Maths Tutorial, at:
http://lounge.windowssecrets.com/ind...owtopic=365442
or
http://www.gmayor.com/downloads.htm#Third_party
In particular, look at the item titled 'Relative Referencing In Tables'.
--
Cheers
macropod
[Microsoft MVP - Word]
"VcDeveloper" wrote in message ...
I have three columns and only calculating col 2. I have a heading so my
calculation starts from row 2. But here is the task.
1) row 2 is my opening balance.
2) every row after this is a amount that is subtracted from the row 2.
3) the last row will contain the closing balance.
I'm creating a monthly budget and this is what I'm able to do so far.
A) {=B2-(SUM(ABOVE))} BUT, I can't seem to add an extra field to subtract
the extra balance.
B) I used {=B2-SUM(B3:B10)} BUT, I don't want to keep changing the last row
number.
Any suggesting on how to optimize this or am I stuck with making the last
row number change?
--
Coding is like a box of chocolates!...