If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.
I have a spreadsheet with a few dozen columns I use for client information and put a new client on every row. I use this information for mail merge with word so I can quickly create letters and have a bunch of information already there.
I would like to create a true/false type field for when clients are closed so I can then get a list of current open clients.
I want to be able to list them on another sheet.
So, is it possible to create a sheet that will list some rows from another sheet based on whether a particular field is true/false?
To summarize, I want to be able to look at a list of current open clients from the list of 800+ clients I have that increases by 10-20 clients per month but I usually close the files on that many per month as well.
This will help make sure I don't overlook a client when I should be working on that file.
Take a look at the attached example.
You can modify the macro to expand for more columns and rows.
On sheet1 you can select "True" or "False" in column A, then press the test button and on sheet2 you will get a list of Rows that had "True" selected.
All rows with "False" in column A will be deleted.
Hope this helps.
modytrane
Thank you, that is what I was looking to do.
I cannot for the life of me figure out how you did it, but it is what I wanted to do so I will try to figure out how you programed that.
Linear Mode
