Copy row if value in column L = unpaid
Closed
                                    
                        Tegan                    
                                    -
                            Jan  2, 2012 at 12:10 AM
                        
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 2, 2012 at 09:17 PM
        venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 2, 2012 at 09:17 PM
        Related:         
- Copy row if value in column L = unpaid
- Saints row 2 cheats - Guide
- How to delete column in word - Guide
- Excel count occurrences of string in column - Guide
- Vb net find last row in excel sheet - Guide
- Tweetdeck expand column - Guide
1 response
                
        
                    venkat1926
    
        
                    Posts
            
                
            1863
                
                            Registration date
            Sunday June 14, 2009
                            Status
            Contributor
                            Last seen
            August  7, 2021
            
            
                    811
    
    
                    
Jan 2, 2012 at 09:17 PM
    Jan 2, 2012 at 09:17 PM
                        
                    at present for this problem no macro is absolutely necessary 
highlight the whole data (or if there are no blanks highlight only A1) then
-click data(menu)-filter-autofilter
you will get arrows in all columns
goto column L and click the arrow
in the download list click "unpaid"
only unpaid rows will be there
highlight filtered data and copy paste to another sheet
now regarding books lots of books are available. But it is difficult to say which is the best books without knowing your standard of knowledge of excel and excel vba
see this thread. The choice of the book also depends upon your personality and background knowledge.
http://www.thecodecage.com/forumz/microsoft-excel-vba-programming/211893-book-excel-visual-basic-applications-absolute-beginner.html
and also
https://www.contextures.com/xlbooks.html
For a beginner it may look confusing
but on intuition I suggest WALKENBACH's book for dummies
REMEMBER YOU MUST GET THE BOOK FOR YOUR VERSION OF EXCEL
I suggest do not buy online. go to a good book store and browse through the books and personally satisfy yourself which book(s) is most suitable to you.
best compliments
            highlight the whole data (or if there are no blanks highlight only A1) then
-click data(menu)-filter-autofilter
you will get arrows in all columns
goto column L and click the arrow
in the download list click "unpaid"
only unpaid rows will be there
highlight filtered data and copy paste to another sheet
now regarding books lots of books are available. But it is difficult to say which is the best books without knowing your standard of knowledge of excel and excel vba
see this thread. The choice of the book also depends upon your personality and background knowledge.
http://www.thecodecage.com/forumz/microsoft-excel-vba-programming/211893-book-excel-visual-basic-applications-absolute-beginner.html
and also
https://www.contextures.com/xlbooks.html
For a beginner it may look confusing
but on intuition I suggest WALKENBACH's book for dummies
REMEMBER YOU MUST GET THE BOOK FOR YOUR VERSION OF EXCEL
I suggest do not buy online. go to a good book store and browse through the books and personally satisfy yourself which book(s) is most suitable to you.
best compliments
