Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
Ray Ray is offline
external usenet poster
 
Posts: 14
Default Repeat formula down a column in a Word 2003 table

I have a table in Word 2003, with 100 rows and 10 columns.



Each row contains cells for gross income and for various expenses then the
net amount. This formula is from the third row. It is placed in the "i"
(9th) column to calculate the net amount of income and expense item:



{=d3-e3-f3-g3-h3 \#"$#,##0.00;($#,##0.00)"}



Then I put it in the fourth row (same column) and each of the 3's are
changed to 4's., and so fourth on down the column. Problem is this is an
extremely slow and tedious process. I know there is a way to do it
automatically. I have done it in the past ..., years ago, but I can't
remember how, and I can not find it in any help file or any of the online
helps. Please point me in the right direction to repeat the formula
(updated for each row) in all the rows of the table.

--
Thanks, Ray


  #2   Report Post  
Posted to microsoft.public.word.tables
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default Repeat formula down a column in a Word 2003 table

I don't know of any way to do this automatically in Word. Are you sure you
aren't thinking of Excel? You can embed an Excel sheet in your Word doc.

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

"Ray" wrote in message
...
I have a table in Word 2003, with 100 rows and 10 columns.



Each row contains cells for gross income and for various expenses then the
net amount. This formula is from the third row. It is placed in the "i"
(9th) column to calculate the net amount of income and expense item:



{=d3-e3-f3-g3-h3 \#"$#,##0.00;($#,##0.00)"}



Then I put it in the fourth row (same column) and each of the 3's are
changed to 4's., and so fourth on down the column. Problem is this is an
extremely slow and tedious process. I know there is a way to do it
automatically. I have done it in the past ..., years ago, but I can't
remember how, and I can not find it in any help file or any of the online
helps. Please point me in the right direction to repeat the formula
(updated for each row) in all the rows of the table.

--
Thanks, Ray



  #3   Report Post  
Posted to microsoft.public.word.tables
macropod macropod is offline
external usenet poster
 
Posts: 1,002
Default Repeat formula down a column in a Word 2003 table

Hi Ray,

Relative row addressing in Word is not directly supported. You can get around it with field coding, though. To see how to do this
and a wide range of other calculations in Word, check out my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442
or
http://www.gmayor.com/downloads.htm#Third_party
Note: AFAIK There's no practical way to implement a flexible form of relative column addressing.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Ray" wrote in message ...
I have a table in Word 2003, with 100 rows and 10 columns.



Each row contains cells for gross income and for various expenses then the net amount. This formula is from the third row. It is
placed in the "i" (9th) column to calculate the net amount of income and expense item:



{=d3-e3-f3-g3-h3 \#"$#,##0.00;($#,##0.00)"}



Then I put it in the fourth row (same column) and each of the 3's are changed to 4's., and so fourth on down the column. Problem
is this is an extremely slow and tedious process. I know there is a way to do it automatically. I have done it in the past ...,
years ago, but I can't remember how, and I can not find it in any help file or any of the online helps. Please point me in the
right direction to repeat the formula (updated for each row) in all the rows of the table.

--
Thanks, Ray


  #4   Report Post  
Posted to microsoft.public.word.tables
Ray Ray is offline
external usenet poster
 
Posts: 14
Default Repeat formula down a column in a Word 2003 table

How would I do that?

"Suzanne S. Barnhill" wrote in message
...
I don't know of any way to do this automatically in Word. Are you sure you
aren't thinking of Excel? You can embed an Excel sheet in your Word doc.

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

"Ray" wrote in message
...
I have a table in Word 2003, with 100 rows and 10 columns.



Each row contains cells for gross income and for various expenses then
the
net amount. This formula is from the third row. It is placed in the "i"
(9th) column to calculate the net amount of income and expense item:



{=d3-e3-f3-g3-h3 \#"$#,##0.00;($#,##0.00)"}



Then I put it in the fourth row (same column) and each of the 3's are
changed to 4's., and so fourth on down the column. Problem is this is an
extremely slow and tedious process. I know there is a way to do it
automatically. I have done it in the past ..., years ago, but I can't
remember how, and I can not find it in any help file or any of the online
helps. Please point me in the right direction to repeat the formula
(updated for each row) in all the rows of the table.

--
Thanks, Ray





  #5   Report Post  
Posted to microsoft.public.word.tables
Ray Ray is offline
external usenet poster
 
Posts: 14
Default Repeat formula down a column in a Word 2003 table

Thanks- I don't know why I had it in my heat so strongly that years ago I
had done something like paste the formula in all the rows then select the
column then pressed some key combination or clicked some menu item and it
updated each formula for with the correct line number in each formula.
Sometime we (humans) get something so strongly in our mind that it becomes a
real memory. I have spent 3 days looking for it and have just about
convinced myself it is not there.

I know it was not Excel because I can look back at the first year I used
this form and it was several years before I even owned or had access to
Excel.

Thanks for all the help!

Ray


"macropod" wrote in message
...
Hi Ray,

Relative row addressing in Word is not directly supported. You can get
around it with field coding, though. To see how to do this and a wide
range of other calculations in Word, check out my Word Field Maths
'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442
or
http://www.gmayor.com/downloads.htm#Third_party
Note: AFAIK There's no practical way to implement a flexible form of
relative column addressing.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Ray" wrote in message
...
I have a table in Word 2003, with 100 rows and 10 columns.



Each row contains cells for gross income and for various expenses then
the net amount. This formula is from the third row. It is placed in the
"i" (9th) column to calculate the net amount of income and expense item:



{=d3-e3-f3-g3-h3 \#"$#,##0.00;($#,##0.00)"}



Then I put it in the fourth row (same column) and each of the 3's are
changed to 4's., and so fourth on down the column. Problem is this is an
extremely slow and tedious process. I know there is a way to do it
automatically. I have done it in the past ..., years ago, but I can't
remember how, and I can not find it in any help file or any of the online
helps. Please point me in the right direction to repeat the formula
(updated for each row) in all the rows of the table.

--
Thanks, Ray






  #6   Report Post  
Posted to microsoft.public.word.tables
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default Repeat formula down a column in a Word 2003 table

I think Word by default has a button on the Standard toolbar for Insert
Microsoft Excel Worksheet.

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

"Ray" wrote in message
...
How would I do that?

"Suzanne S. Barnhill" wrote in message
...
I don't know of any way to do this automatically in Word. Are you sure

you
aren't thinking of Excel? You can embed an Excel sheet in your Word doc.

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

"Ray" wrote in message
...
I have a table in Word 2003, with 100 rows and 10 columns.



Each row contains cells for gross income and for various expenses then
the
net amount. This formula is from the third row. It is placed in the

"i"
(9th) column to calculate the net amount of income and expense item:



{=d3-e3-f3-g3-h3 \#"$#,##0.00;($#,##0.00)"}



Then I put it in the fourth row (same column) and each of the 3's are
changed to 4's., and so fourth on down the column. Problem is this is

an
extremely slow and tedious process. I know there is a way to do it
automatically. I have done it in the past ..., years ago, but I can't
remember how, and I can not find it in any help file or any of the

online
helps. Please point me in the right direction to repeat the formula
(updated for each row) in all the rows of the table.

--
Thanks, Ray






  #7   Report Post  
Posted to microsoft.public.word.tables
Ray Ray is offline
external usenet poster
 
Posts: 14
Default Repeat formula down a column in a Word 2003 table

Hi macropod, I've looked at your beautiful paper, but I can't find exactly
where you address this issue. Which section is it in?
Thanks, Ray


"macropod" wrote in message
...
Hi Ray,

Relative row addressing in Word is not directly supported. You can get
around it with field coding, though. To see how to do this and a wide
range of other calculations in Word, check out my Word Field Maths
'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442
or
http://www.gmayor.com/downloads.htm#Third_party
Note: AFAIK There's no practical way to implement a flexible form of
relative column addressing.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Ray" wrote in message
...
I have a table in Word 2003, with 100 rows and 10 columns.



Each row contains cells for gross income and for various expenses then
the net amount. This formula is from the third row. It is placed in the
"i" (9th) column to calculate the net amount of income and expense item:



{=d3-e3-f3-g3-h3 \#"$#,##0.00;($#,##0.00)"}



Then I put it in the fourth row (same column) and each of the 3's are
changed to 4's., and so fourth on down the column. Problem is this is an
extremely slow and tedious process. I know there is a way to do it
automatically. I have done it in the past ..., years ago, but I can't
remember how, and I can not find it in any help file or any of the online
helps. Please point me in the right direction to repeat the formula
(updated for each row) in all the rows of the table.

--
Thanks, Ray




  #8   Report Post  
Posted to microsoft.public.word.tables
macropod macropod is offline
external usenet poster
 
Posts: 1,002
Default Repeat formula down a column in a Word 2003 table

Hi Ray,

Page 4 - Relative Referencing In Tables

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Ray" wrote in message ...
Hi macropod, I've looked at your beautiful paper, but I can't find exactly
where you address this issue. Which section is it in?
Thanks, Ray


"macropod" wrote in message
...
Hi Ray,

Relative row addressing in Word is not directly supported. You can get
around it with field coding, though. To see how to do this and a wide
range of other calculations in Word, check out my Word Field Maths
'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442
or
http://www.gmayor.com/downloads.htm#Third_party
Note: AFAIK There's no practical way to implement a flexible form of
relative column addressing.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Ray" wrote in message
...
I have a table in Word 2003, with 100 rows and 10 columns.



Each row contains cells for gross income and for various expenses then
the net amount. This formula is from the third row. It is placed in the
"i" (9th) column to calculate the net amount of income and expense item:



{=d3-e3-f3-g3-h3 \#"$#,##0.00;($#,##0.00)"}



Then I put it in the fourth row (same column) and each of the 3's are
changed to 4's., and so fourth on down the column. Problem is this is an
extremely slow and tedious process. I know there is a way to do it
automatically. I have done it in the past ..., years ago, but I can't
remember how, and I can not find it in any help file or any of the online
helps. Please point me in the right direction to repeat the formula
(updated for each row) in all the rows of the table.

--
Thanks, Ray




  #9   Report Post  
Posted to microsoft.public.word.tables
Ray Ray is offline
external usenet poster
 
Posts: 14
Default Thanks! R. Repeat formula down a column in a Word 2003 table

Thanks!
Ray


"macropod" wrote in message
...
Hi Ray,

Page 4 - Relative Referencing In Tables

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Ray" wrote in message
...
Hi macropod, I've looked at your beautiful paper, but I can't find
exactly where you address this issue. Which section is it in?
Thanks, Ray


"macropod" wrote in message
...
Hi Ray,

Relative row addressing in Word is not directly supported. You can get
around it with field coding, though. To see how to do this and a wide
range of other calculations in Word, check out my Word Field Maths
'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442
or
http://www.gmayor.com/downloads.htm#Third_party
Note: AFAIK There's no practical way to implement a flexible form of
relative column addressing.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Ray" wrote in message
...
I have a table in Word 2003, with 100 rows and 10 columns.



Each row contains cells for gross income and for various expenses then
the net amount. This formula is from the third row. It is placed in
the "i" (9th) column to calculate the net amount of income and expense
item:



{=d3-e3-f3-g3-h3 \#"$#,##0.00;($#,##0.00)"}



Then I put it in the fourth row (same column) and each of the 3's are
changed to 4's., and so fourth on down the column. Problem is this is
an extremely slow and tedious process. I know there is a way to do it
automatically. I have done it in the past ..., years ago, but I can't
remember how, and I can not find it in any help file or any of the
online helps. Please point me in the right direction to repeat the
formula (updated for each row) in all the rows of the table.

--
Thanks, Ray




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
error messages when using table formula after moving column tot's hunguponword Tables 3 November 26th 06 04:27 AM
Word 2003 Table Formula Number format displays errors. Mark Microsoft Word Help 2 April 6th 06 06:51 AM
Word 2003 Table cell formula Terry Tables 1 June 5th 05 08:59 AM
Word 2003 Table Header Row won't repeat. LindaB Tables 1 March 14th 05 03:39 PM
Word 2003 Table Header Row won't repeat. Linda B Tables 1 November 29th 04 02:28 PM


All times are GMT +1. The time now is 12:41 PM.

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

About Us

"It's about Microsoft Word"