Hi All,

I have a problem with how to do the above. I have cell A1 which for example might say 'Danny' in worksheet one. In worksheet 2 cell A1 has 'fine'. I would like to then write a sentence in Worksheet 2 cell A2 that says. Danny's health is fine. The way I thought it should be written is as below.

=&Sheet1!A1 "'s health is " &A1
but of course this doesn't work. Is this because it can only include one other cell? Can anyone help please?

Thanks

Danny