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
Based on the cell values in cells b77 - Excel Forum
Clear only the formatting from the selected cell (leaving the content) - Guide
If cell contains date then return value ✓ - Excel Forum
Excel "IF" function w/ date in test cell ✓ - Excel Forum
Fill adjacent cell with number from text answer ✓ - 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

Highlight cell if another cell contains specific text

If cell = date return yes or no.

Counting cells containing only numbers

Similar discussions

Subscribe To Our Newsletter!