Hi Dee,
I take it you're using coding based on the example from Column E. For your second and subsequent tables, you'd be better off
changing the SEQ field names and 'CellA' etc bookmarks. Otherwise, you'll have to delete the '/2' divisors for the second table, at
which point you could run into problems with Word trying to use two copies of the same 'CellA' etc bookmarks. It gets even more
complicated if you go to three or more tables and try to reuse the SEQ fields and 'CellA' etc bookmarks.
Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------
"dee" wrote in message ...
Yes, I did examine the code. I then copied and pasted it into my table and
modified the * for - and it worked fine for the first table.
When it got to the 2nd table, it stopped working. I realize that I need to
add an r switch to get it to restart the numbering with 1, but when I try to
do this, I get a syntax error.
I then tried to start from scratch, but, again, syntax error. This is what
I did:
Insert menu, Field, Quote (which I am honestly not sure why using)
Ctrl F9
Type =b
Insert field - seq rownum
type -c
Insert field - seq rownum \c
I then hit F9 and get Syntax Error.
I'm obviously missing something and any help would be greatly appreciated.
Thanks so much.
--
Thanks!
Dee
"macropod" wrote:
Hi Dee,
Did you examine the field coding? To do so, select one of the fields and press Shift-F9. You might find it easier if you copy the
field out of the table and paste it somewhere where the cell boundaries won't constrain the layout.
Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------
"dee" wrote in message ...
Hi there,
Yes, I had read you information today. I'm sorry, but I just don't grasp
how to incorporate a Seq field within my formula to reference the correct
relative address. (I'm blonde! :-) )
My thought was to reference the row number, somehow having something like:
=a(seq field)-b(seq field)
I have a feeling I'm totally off base.
Any help (baby step-by-step) would be greatly appreciated.
--
Thanks!
Dee
"macropod" wrote:
To see how to do this, 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
In particular, look at the item titled 'Relative Referencing In Tables'
Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------
"dee" wrote in message ...
Hi,
I've found some guidance through the posts regarding "relative" cell
addresses within a table, but can't seem to figure out exactly how to input
the formula using the Seq field.
For example, say I have a table with 3 columns and 3 rows. I want to be
able to input a formula in cell C1 that will subtract A1-B1.
Using an absolute formula won't work, as I will be revising the table every
month. I had thought of embedding an Excel file, but for what I'm doing, it
isn't feasible.
Can anyone help with the exact syntax of how to achieve this? Every time I
try, I get a syntax error.
Thanks!
--
Thanks!
Dee