Reference and tranpose cell information

Rokky - Feb 2, 2022 at 11:03 AM
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
- Feb 8, 2022 at 11:35 AM
Hello,
I am trying to get get the formula in SHEET 2 ROW 3 to copy the data from SHEET 1 COLUMN D.

I tried to just copy and paste or copy and drag but the cell only references the data in the ROWS for SHEET 1.


System Configuration: Windows / Chrome 97.0.4692.99

1 reply

TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
510
Feb 8, 2022 at 11:35 AM
Hi Rokky,

I don't think I fully understand your query.

You can just type an "=" on sheet 2 row 3 and then select the cell you want to link on sheet 1 column D.

Best regards,
Trowa
0