Hello,

Perhaps I need to explain this differently to my earlier post

if I put the number "1" in cell A1 on Sheet 1 and I would like cell A1 on Sheet 2 to read "2" then I use this formula ='Sheet1'!A1+1... simple enough

But when I introduce a word such as "name1", when I use the same formula is does not work, I would like the cell A1 on Sheet 2 to read "name2"

Please help!!!!!!!