#spill errors for duplicating text

Occasional Visitor

In a workbook i have 2 worksheets. In worksheet 1 i have a block of merged cells that free text is to be captured in, in Worksheet 2 i have merged cells that needs to show the text capture on worksheet 1 (in the merged cells. I have been getting #spil errors and now i just get ='Front Page'!d32:h35.

 

How can i fix this to that the text is capture in one place and is also visible in another.

1 Reply
Un-merge the cells (at least on Worksheet 2) and try this:
='Front Page'!d32:d35