Auto populate specific data from sheet to another
Closed
V_torres
Posts
1
Registration date
Sunday April 22, 2018
Status
Member
Last seen
April 22, 2018
-
Apr 22, 2018 at 10:33 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Apr 23, 2018 at 11:56 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Apr 23, 2018 at 11:56 AM
Related:
- How to auto populate data in excel from another worksheet
- How to copy data from one excel sheet to another - Guide
- Excel move data from one sheet to another - Guide
- Export data from excel - Guide
- How to copy data to multiple worksheets in Excel - Guide
- How to reset safe folder password without losing data ✓ - Android Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 27, 2022
555
Apr 23, 2018 at 11:56 AM
Apr 23, 2018 at 11:56 AM
Hi V_torres,
Seems to me you are asking to link cells, where both cells display the same result.
In BJ4 type an "=", then go to sheet 1 and select F4, then hit Enter to confirm the formula.
Now drag BJ4 1 cell to the right and when the small option box appears, choose the option to apply without format. Now select both BJ4 and BK4 and drag them down as far as needed.
Best regards,
Trowa
Seems to me you are asking to link cells, where both cells display the same result.
In BJ4 type an "=", then go to sheet 1 and select F4, then hit Enter to confirm the formula.
Now drag BJ4 1 cell to the right and when the small option box appears, choose the option to apply without format. Now select both BJ4 and BK4 and drag them down as far as needed.
Best regards,
Trowa
