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
Hello,

I am completely lost with using macros. I can't seem to find a beginners guide for using macros on a mac. I've read several threads that solve this problem for other people (e.g. http://ccm.net/faq/4668-copy-rows-based-on-a-condition#q=Copy+rows+by+column+match+condition&cur=3&url=%2F), but without a basic knowledge of macros, this is beyond me.

Here is what I am trying to do. I have a spreadsheet listing customer transactions with column L being Payment Date. I would like to automatically copy any rows with Payment Date equaling "unpaid" to a new worksheet so that my secretary can go to the dashboard and see a list of sales that need her to process payment.

I could probably use the solution from the other thread and try to enter my own values, if someone could tell me the beginning steps to getting the macro started.

Perhaps this seems silly to try when I do not have experience with macros. Could someone recommend an online guide that will help?

Thank you!

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
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
0