Copying entries from multiple sheets to new sheet, then summing
Solved/Closed
                    
        
                    polyrhythm
    
        
                    Posts
            
                
            1
                
                            Registration date
            Sunday November  8, 2015
                            Status
            Member
                            Last seen
            November  8, 2015
            
                -
                            Nov  8, 2015 at 10:33 AM
                        
nahidule Posts 2 Registration date Sunday November 1, 2015 Status Member Last seen March 11, 2016 - Nov 9, 2015 at 10:00 AM
        nahidule Posts 2 Registration date Sunday November 1, 2015 Status Member Last seen March 11, 2016 - Nov 9, 2015 at 10:00 AM
        Related:         
- Copying entries from multiple sheets to new sheet, then summing
 - Sheet right to left google sheets - Guide
 - Windows network commands cheat sheet - Guide
 - Little alchemy cheat sheet - Guide
 - How to copy data from one excel sheet to another - Guide
 - Protect pdf from copying - Guide
 
2 responses
                
        
                    rizvisa1
    
        
                    Posts
            
                
            4478
                
                            Registration date
            Thursday January 28, 2010
                            Status
            Contributor
                            Last seen
            May  5, 2022
            
            
                    766
    
    
                    
Nov 9, 2015 at 09:46 AM
    Nov 9, 2015 at 09:46 AM
                        
                    I think you would need to create a macro to create the cummulative sheet or atleast update the sheet
this is how i would have proceeded
1. copy from sheet1 to sheet5, the team name in a temp sheet, in a single column
2. use advance filter to get the unique list
3. copy the unique name to commulative sheet
then you can use vlookup easily
            this is how i would have proceeded
1. copy from sheet1 to sheet5, the team name in a temp sheet, in a single column
2. use advance filter to get the unique list
3. copy the unique name to commulative sheet
then you can use vlookup easily
                
        
                    nahidule
    
        
                    Posts
            
                
            2
                
                            Registration date
            Sunday November  1, 2015
                            Status
            Member
                            Last seen
            March 11, 2016
            
                    
Nov 9, 2015 at 10:00 AM
    Nov 9, 2015 at 10:00 AM
                        
                    Nice, helpful resource.
                
                
            
        
    
    
    
    


