View Single Post
  #5   Report Post  
Posted to microsoft.public.word.newusers
Paulnet
 
Posts: n/a
Default Word table formula problem.

Thanks Suzanne. I will check that out.

"Suzanne S. Barnhill" wrote:

See http://word.mvps.org/FAQs/MacrosVBA/UsingRecorder.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Paulnet" wrote in message
...
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.

"Cooz" wrote:

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
--
PS: If this is a satisfactory answer to your question, and you are

logged in
via Microsoft, please press the "Yes" button next to "Did this post

answer
the question?". Thank you.

"Paulnet" wrote:

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?