Can anyone tell me how I might combine to cells to generate a thrird cell
content which calls data from an external reference e.g. I am in wb1.xls and
I have two cells a1 and b1. c1 = a1&b1. a1 = the file name of the external
source, wb2.xls and b1 = the cell reference in wb2. This is so that i can
keep cell rfernces constant but with variable file names. the problem I have
is that I need to make this concatenated cell, c1 operate as =a1+b2 but I
only seem to be able to intorduce the = sign as text.