Forum Discussion
Cell references do not display
Hello, I think my question is so simple that no one has ever posted an answer to it. I am trying to reference a range of cells from another sheet in the same workbook. In my current sheet, I ...
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.
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.
That means your Excel doesn't support dynamic arrays. Simplest way add to B2 ='Group Calendar'!A2 and drag to the right.