Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.newusers
Paulnet
 
Posts: n/a
Default Word table formula problem.

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?
  #2   Report Post  
Posted to microsoft.public.word.newusers
Cooz
 
Posts: n/a
Default Word table formula problem.

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?

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

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?

  #4   Report Post  
Posted to microsoft.public.word.newusers
Suzanne S. Barnhill
 
Posts: n/a
Default Word table formula problem.

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?


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



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word should catalog misspelled words to study. rndthought Microsoft Word Help 39 May 21st 23 02:47 AM
Does Word have a QuickCorrect/Quick Word option like WordPerfect? CW New Users 2 December 20th 05 05:54 PM
In Word, how do I surpress headers and footers on page 2 Bill Microsoft Word Help 1 December 15th 05 06:13 PM
Underscore (_) will not always display in RTF files (Word 2002). David A Edge Microsoft Word Help 6 June 14th 05 10:39 AM
Envelope Address GR New Users 5 April 24th 05 09:48 PM


All times are GMT +1. The time now is 11:22 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"