Hello all,

First time poster here. Any help would be greatly appreciated.

I am trying to type text in e.g. sheet1 cell A2 and get that same text to show automatically in sheet 2 cell B3

I have kind of worked it out, I use a formula like so:

='C:\Documents and Settings\Administrator\Desktop\[example.xls]Sheet1'!A2

That will work, but when I try to make any changes to that string, e.g. change cell A2 to A3 the formula just shows as text in the destination cell.

Thanks in advance

P.s. I'm using Excel 2002