Happiness is data appearing in the required places correctly!
Again, many thanks for your generous help.

Ken Rock
"JE McGimpsey" wrote in message
...
If your cells are formatted as Text, XL doesn't parse the entry. Format
them as General and reenter the formulas.

In article ,
"Ken Rock" wrote:

Many thanks for your prompt response.
I'm sure this will work since I managed to get the hoped-for result once.
However, subsequent attempts only resulted in the formula being shown in
the
cell - not the data pointed to.
I've had this before even for simple "=Sheet1!C4" formula trials. Is it
a
formatting error? Changing the cell address values in the Formula Bar
manually also brings about this phenomena.