Copy automatically columns if the criteria is met
Solved/Closed
                                    
                        kerwin                    
                                    -
                            Jul 29, 2021 at 05:59 AM
                        
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Jul 29, 2021 at 12:11 PM
        TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Jul 29, 2021 at 12:11 PM
        Related:         
- Copy automatically columns if the criteria is met
 - Tweetdeck larger columns - Guide
 - Download automatically while roaming - Guide
 - Why does facebook refresh itself automatically - Guide
 - Idm stop adobe downloads automatically - Guide
 - How to refresh outlook inbox automatically - Guide
 
1 response
                
        
                    TrowaD
    
        
                    Posts
            
                
            2921
                
                            Registration date
            Sunday September 12, 2010
                            Status
            Contributor
                            Last seen
            December 27, 2022
            
            
                    555
    
    
                    
Jul 29, 2021 at 12:11 PM
    Jul 29, 2021 at 12:11 PM
                        
                    Hi Kerwin,
Why not use VBA? It would be the best and easiest way.
If you really want to use formula's I guess you could use:
Sheet2 A2: =IF(Sheet1!$C2="Mitigate",Sheet1!A2,"")
Drag the cell to C2, then select A2 to C2 and drag that selection down.
On sheet2 you can apply an autofilter (found on the data ribbon) to get the data next to each other, without empty rows in between.
Best regards,
Trowa
 
                
                
            Why not use VBA? It would be the best and easiest way.
If you really want to use formula's I guess you could use:
Sheet2 A2: =IF(Sheet1!$C2="Mitigate",Sheet1!A2,"")
Drag the cell to C2, then select A2 to C2 and drag that selection down.
On sheet2 you can apply an autofilter (found on the data ribbon) to get the data next to each other, without empty rows in between.
Best regards,
Trowa