Cell references do not display

Question

Hello,&nbsp;I think my question is so simple that no one has ever posted an answer to it.&nbsp;I am trying to reference a range of cells from another sheet in the same workbook. In my current sheet, I need the data in cells B2:D2 to display the same data from another sheet A2:C2. I have tried ='Group Calendar'!A3:C3 and I get the #VALUE error. Can you please help?&nbsp;I don't need to operate this data, just display it in three adjacent cells the way it is displayed in another sheet. Thank you.&nbsp;Best, gabrielsolomon7

detlef_lewin · Answer

gabrielsolomon7&nbsp;Why do reference A3:C3 if you want data from A2:C2?&nbsp;In B2:='Group Calendar'!A3And copy to the right.&nbsp;

gabrielsolomon7 · Answer

Hello, thanks for replying,I'm trying to get sheet 1 data A2:C2 to display in sheet 2 B2:D2. When I enter ='Group Calendar'!A2:C2 only the data from the leftmost cell is displayed.

sergeibaklan · Answer

gabrielsolomon7&nbsp;
That means your Excel doesn't support dynamic arrays. Simplest way add to B2&nbsp;='Group Calendar'!A2 and drag to the right.

gabrielsolomon7 · Answer

Thanks Sergei. Is there a way to get my excel to support dynamic arrays? Because I have a LOT of these. Thanks.

bosinander · Answer

Change to 365 or buy an upgrade to the next stale version, expected soon.Older versions also have some array possibilities but hardly worth the while anymore since 365 has sooo many new and great features.

Forum Discussion

Cell references do not display

7 Replies

Resources