I am needing a little help with linking data in one cell to another. I simply want to carry the information entered on one sheet to carry to another sheet. But, I must be doing something wrong.
Sheet 1, D1:D16 is a merged cell that I wish to carry to Sheet 2, J16:J26 as a merged cell. Each of the merged cells is the same size, font, row height, format, etc.
I've tried:
=Sheet1!D1
=Sheet1!D1:D16
=INDIRECT(Sheet1!D1:D16)
On one of the approaches above I do get an error that says the the merged cells must be exactly the same which I think I've done. All other attempts just show the formula in the cell block and no errors.
Any ideas what I'm doing wrong?
Sheet 1, D1:D16 is a merged cell that I wish to carry to Sheet 2, J16:J26 as a merged cell. Each of the merged cells is the same size, font, row height, format, etc.
I've tried:
=Sheet1!D1
=Sheet1!D1:D16
=INDIRECT(Sheet1!D1:D16)
On one of the approaches above I do get an error that says the the merged cells must be exactly the same which I think I've done. All other attempts just show the formula in the cell block and no errors.
Any ideas what I'm doing wrong?