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

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?

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?

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?