I have 2 sheets in a workbook. Sheet 1 has cells C1, D1, E1 merged, with
text in the merged cell. In sheet 2, cells E1,F1,G1 are merged. I want the
cells on sheet 2 to equal the text in sheet one, but if I type =, then click
on cells in sheet 1, I get a value# error. Can anyone help? Doesn't seem as
if it should be difficult.

Thanks!