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 a row in a table in word - Guide
- Display two columns in data validation list but return only one - Guide
- Saints row free download - Download - Action and adventure
- Tweetdeck remove 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