Forum Discussion
M_A_T_T
Oct 13, 2022Copper Contributor
#spill errors for duplicating text
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
Sort By
- JMB17Bronze ContributorUn-merge the cells (at least on Worksheet 2) and try this:
='Front Page'!d32:d35