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 Contributor Last seen December 27, 2022 - Nov 4, 2014 at 11:57 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Nov 4, 2014 at 11:57 AM
Related:
- How to transfer current data from one sheet to another sheet
- How to copy data from one excel sheet to another - Guide
- Sheet right to left in google sheet - Guide
- Windows network commands cheat sheet - Guide
- Excel move data from one sheet to another - Guide
- How to transfer ff id from facebook to google - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 27, 2022
555
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