Autofilter fails to sort data.
Closed
                                    
                        Carman                    
                                    -
                            Jul 14, 2010 at 03:43 AM
                        
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 18, 2010 at 08:55 AM
        rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 18, 2010 at 08:55 AM
        Related:         
- Autofilter fails to sort data.
 - Sort chrome bookmarks alphabetically - Guide
 - Tmobile data check - Guide
 - Data transmission cable - Guide
 - Download facebook data - Guide
 - Transfer data from one excel worksheet to another automatically - Guide
 
2 responses
                        
                    bascially, my heading got filtered away.
All i want to do is REMOVE rows that
1) without the word "pending"
2) NOT blank
            All i want to do is REMOVE rows that
1) without the word "pending"
2) NOT blank
                
        
                    rizvisa1
    
        
                    Posts
            
                
            4478
                
                            Registration date
            Thursday January 28, 2010
                            Status
            Contributor
                            Last seen
            May  5, 2022
            
            
                    766
    
    
                    
Jul 18, 2010 at 08:55 AM
    Jul 18, 2010 at 08:55 AM
                        
                    Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site  , http://docs.google.com, http://wikisend.com/  , http://www.editgrid.com  etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too