Word table formula problem.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a table in Word. The formula I have used is where, for example
the value of d1 is the sum of a1,b1 and c1, the value of d2 is the sum of
a2,b2 and c2 and so on. When I first set the table up I listed the rows of
data in descending numerical order based on the sums in column d. However
when I add new data to columns a,b, or c, thus changing the values in column
d, the rows are no longer in descending numerical order. Is there a command I
can use to keep them in order?
 
Hi Paulnet,

I suggest you sort your table again after you've added new data. In Word
this cannot be done automatically.
What you can do, is record a macro that A. updates your fields to assure
column d contains the right values, and B. sorts your table. Make a button
for this macro. That is about as user friendly as you can get it.

Another option may be to implement this in Excel, which of course is far
more flexible in working with tables.

Good luck,
Cooz
 
Thanks for the reply Cooz. How do I create a macro? Ive never used excel
before so I wanted to try and do it in word.
 
Back
Top