Validate copied data in excel
Solved/Closed
                    
        
                    chint99
    
        
                    Posts
            
                
            2
                
                            Registration date
            Wednesday June 21, 2017
                            Status
            Member
                            Last seen
            June 22, 2017
            
                -
                            Jun 21, 2017 at 10:57 AM
                        
chint99 Posts 2 Registration date Wednesday June 21, 2017 Status Member Last seen June 22, 2017 - Jun 22, 2017 at 08:51 PM
        chint99 Posts 2 Registration date Wednesday June 21, 2017 Status Member Last seen June 22, 2017 - Jun 22, 2017 at 08:51 PM
        Related:         
- Validate copied data in excel
- Excel mod apk for pc - Download - Spreadsheets
- Transfer data from one excel worksheet to another automatically - Guide
- Display two columns in data validation list but return only one - Guide
- Tmobile data check - Guide
- Gif in excel - Guide
1 response
                
        
                    TrowaD
    
        
                    Posts
            
                
            2921
                
                            Registration date
            Sunday September 12, 2010
                            Status
            Contributor
                            Last seen
            December 27, 2022
            
            
                    555
    
    
                    
Jun 22, 2017 at 11:03 AM
    Jun 22, 2017 at 11:03 AM
                        
                    Hi Chint99,
It might just be a confusing example, but all I get from your query is that R2 needs to match R1.
Also, Excel doesn't keep track of all the different entry's made to a cell. So the Original value might be 2, when it is replaced by 1, then the 2 is lost. If you want to keep track of your entries use another row.
Best regards,
Trowa
 
                
                
            It might just be a confusing example, but all I get from your query is that R2 needs to match R1.
Also, Excel doesn't keep track of all the different entry's made to a cell. So the Original value might be 2, when it is replaced by 1, then the 2 is lost. If you want to keep track of your entries use another row.
Best regards,
Trowa
 
        
    
    
    
    
Updated on Jun 22, 2017 at 08:51 PM