Reference and tranpose cell information

Closed

Rokky - Feb 2, 2022 at 11:03 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 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

Formula ref
Count if cell contains number - Excel Forum
Cell phone battery reset code - Guide
Insert a function in cell b2 to display the current date from your system. ✓ - Excel Forum
If cell contains date then return value - Excel Forum
Excel "IF" function w/ date in test cell ✓ - Excel Forum

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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

Similar discussions

help me to add particular cells

If a cell contains any text then add a value

If cell = date return yes or no.

Fill adjacent cell with number from text answer

Excel function question

Similar discussions

Subscribe To Our Newsletter!