Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
How can formula output be updated when rows &/or columns are added
How can the results of formulas in WORD tables be updated, when not only the
input data referenced by the formulas changes, but rows &/or columns are added or subtracted to the table containing the formula(s), thus changing the cell locations referenced by the formula(s)? I assume (fingers crossed) there is a way to do this? Replies appreciated. Example: Formula in cell G4 . . . =E4*F4. Then a row is added above, so that G4 becomes G5. How, other than actually editing the formula each time this happens, can the formula be made to continue working properly? |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
How can formula output be updated when rows &/or columns are added
Unlike Excel where this sort of thing is handled transparently, Word tables
only hold what you put into them. You will either have to bookmark the items you wish to calculate and then use eg {={Bookmarkname1} * {BookmarkName2}} as the bookmark names will always apply to the same content whatever you add (provided you don't destroy the bookmarks in the process) or you could do all the mathematics in Excel and paste a link from the Excel table into the Word document. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org mkraft wrote: How can the results of formulas in WORD tables be updated, when not only the input data referenced by the formulas changes, but rows &/or columns are added or subtracted to the table containing the formula(s), thus changing the cell locations referenced by the formula(s)? I assume (fingers crossed) there is a way to do this? Replies appreciated. Example: Formula in cell G4 . . . =E4*F4. Then a row is added above, so that G4 becomes G5. How, other than actually editing the formula each time this happens, can the formula be made to continue working properly? |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
How can formula output be updated when rows &/or columns are a
"Graham Mayor" wrote:
You will either have to bookmark the items you wish to calculate and then use eg {={Bookmarkname1} * {BookmarkName2}} as the bookmark names will always apply to the same content whatever you add Thanks. Can the bookmarking you refer to be done from the 'Insert' (Bookmark) dropdown menu, or is it necessary to use codes? If the latter, can you suggest where I might find a good explanation of how to use them -- i.e., specifically the Bookmarkname codes? |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
How can formula output be updated when rows &/or columns are a
You can use the insert bookmark command.
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org mkraft wrote: "Graham Mayor" wrote: You will either have to bookmark the items you wish to calculate and then use eg {={Bookmarkname1} * {BookmarkName2}} as the bookmark names will always apply to the same content whatever you add Thanks. Can the bookmarking you refer to be done from the 'Insert' (Bookmark) dropdown menu, or is it necessary to use codes? If the latter, can you suggest where I might find a good explanation of how to use them -- i.e., specifically the Bookmarkname codes? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mailmerge using columns instead of rows | Mailmerge | |||
Hiding Rows and Columns | Tables | |||
'Tables'- 2 columns,4 rows. Can you merge one column into 3 rows? | Tables | |||
convert columns into rows | Tables | |||
Mailmerge wont see Added Excel Data source Columns | Mailmerge |