Auto fill cell from another cell
Hi Nadine,
Word's cell referencing only works with numbers - for text you get nothing
and dates & times get horribly mashed. You basically have three options:
1. Set the document up as a protected form, as Doug suggested, and use REF
fields to replicate the text;
2. Use an embedded Excel worksheet, which your users would have to learn how
to use; or
3. Use a macro to replicate the data. This wouldn't give the immediacy of
either of the other options, though, and would have to be run periodically
(eg upon saving/printing or when the user decides).
Cheers
"Nadine" wrote in message
...
Client has a table with multiple columns, but when filles in the cells in
one
column they want the last column to auto fill with the same information
that
is being entered. But it's not numbers, it's text. I know how to relate
cells in Excel, but haven't been able to get it to work in Word - appears
only to work with numbers, but client is filling in text. I'm assuming
there
has to be some kind of formula in word to be able to do this.
Any help would be appreciated.Thanks
|