Problem linking cells between sheets

[WKBX]

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?

 

[schielrn]

I would think your first solution would be correct?

Can you just oress = and then go select the cell?

 

[Andrew Poulsom]

I had no problem with the formula:

=Sheet1!D1

provided the target cell wasn't formatted as Text.

That said D1:D16 has 16 rows, whereas J16:J26 has only 11, so the ranges aren't the same size.

 

[WKBX]

The problem was having the destination formatted as text. I never would have known. Thanks very much.

Keith

 

[WKBX]

However, when I change the entry to my actual formula it doesn't work again. It works as =HELOCApprovalPage1!N16, but not when I have spaces in the sheet tab and change the entry to ='HELOC Approval Page 1'!N16. I really need the spaces in the sheet name and I thought the single quotes were to identify if spaces are present.

What am I doing wrong?

 

[Andrew Poulsom]

There is nothing wrong with:

='HELOC Approval Page 1'!N16

If it doesn't work check the name of the sheet, or enter the formula by typing = and pointing with your mouse.