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
 - Google sheet right to left - 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
        
    
    
    
    

