Can anyone provide help on this one?
I have one page that lists horizontally multiple projects. In column A I list vertically several tasks that may, or may not apply to any given project, but I need to quickly sort the column for the project to exclude the n/a items. (See images below)
How can I use a checkbox or button on each column to quickly filter out cells that are marked n/a for that column?
Excel Document template HERE: Book1.xlsx
2019-08-28_21-24-40.png
2019-08-28_21-23-49.png
Last edited by Wheelcruz; 08-28-2019 at 11:12 PM.
Please attach workbook instead of pictures if you want the problem is solved quickly.
Just updated my original post. THANKS
Assign below macro for each of all checkboxes.
Please Login or Register to view this content.
This is excellent. Thank you much.
What you have sorts by only showing "=N/A", how do I get that to say NOT EQUAL to "NA"?
Also, is it possible that when I click a second checkbox, that it automatically uncheck the first? This way only one checkbox can be selected at a time.
THANKS!
Last edited by Wheelcruz; 08-29-2019 at 08:44 AM.
With below code, when you click on a checkbox, other checkboxs will be uncheck. It mean only one column is filtered at a time.
If you want to filter with criteria is NOT EQUAL to "NA", please change "=N/A" to "<>N/A"
Please Login or Register to view this content.
This was perfect, thank you much. Is it possible to filter more that one item than <>N/A ?
Like when you filter normally, you can filter by a list of exactly items, one criteria or two criterias combined by AND or OR.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks