Oct 16 2023 09:18 AM
I want to "link" a merged cell with another merged cell on a separate page of the same workbook using the the = formula. When I do it, it's giving me a SPILL error message about the merged cell. The cell I am copying TO is merged with three cells, and the cell I am copying FROM is merged with three cells.
Within my workbook I am using this formula successfully without error using merged cells. So I don't understand why I can't do it now.
Oct 16 2023 12:44 PM
If you want to refer to merged cells, refer to the first of the cells, not to the merged range.
For example, if A1, B1 and C1 have been merged, use
=A1
and not
=A1:C1
Oct 16 2023 01:53 PM