How to transfer current data from one sheet to another sheet
Closed
Sanjoangel
Posts
2
Registration date
Monday October 27, 2014
Status
Member
Last seen
October 28, 2014
-
Oct 28, 2014 at 08:15 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 4, 2014 at 11:57 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 4, 2014 at 11:57 AM
Related:
- How to transfer current data from one sheet to another sheet
- Transfer data from one excel worksheet to another automatically - Guide
- Free fire transfer - Guide
- Little alchemy cheat sheet - Guide
- Google sheet right to left - Guide
- How to screenshot excel sheet - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Nov 4, 2014 at 11:57 AM
Nov 4, 2014 at 11:57 AM
Hi Sanjoangel,
So if I understand you correctly the result for SEF 263 should be 170+44+80=294
Why don't you use SUM at the bottom of each column (or anywhere else) and then refer to that cell in sheet 2.
To do that go to C4 of sheet 2, type =, then select the cell on sheet 1 which you put the SUM formula in and hit enter.
Best regards,
Trowa
So if I understand you correctly the result for SEF 263 should be 170+44+80=294
Why don't you use SUM at the bottom of each column (or anywhere else) and then refer to that cell in sheet 2.
To do that go to C4 of sheet 2, type =, then select the cell on sheet 1 which you put the SUM formula in and hit enter.
Best regards,
Trowa
