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.
