Excel Filter Question

I would like to filter just one column in a table but when I select the filter option on the Data tab it filters all columns. Is there anyway to filter just one? I read somewhere where I would need to modify the VB but I am not quiet sure what the VB statement should look like.
SAW56Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Raheman M. AbdulSenior Infrastructure Support Analyst & Systems DeveloperCommented:
Table in Excel you mean or in Access? Cant get to be honest.
I guess when you click filter option in Data Tab, you get the arrow symbol for all the columns which does not mean that they are filtered.
You can just click on the arrow for that column which you are interested in to filter.
If you can attach the sample file, it will be easy for experts to help.
0
ArgentiCommented:
Hi there,

1. What is your Excel version?
2. Do you filter data programatically or you just do it by hand, directly on the spreadsheet?
3. What to you mean by "when I select the filter option on the Data tab it filters all columns" ? It's the fact that it shows ComboBoxes on each field of your data? You know you can reset the whole filter by clicking on the Filter button to unfilter, then once again to enable the combo-boxes on each column. After checking a filter condition on a column, its drop-down arrow changes the colour, so you know that column is having a filter applied.
0
SAW56Author Commented:
It is Excel 2010
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

SAW56Author Commented:
Answers to Argenti's questions.
1.What is your Excel version? Excel 2010
2. Do you filter data programatically or you just do it by hand, directly on the spreadsheet? I have tried directly in the spreadsheet and it always selects all the columns even when I try to use the advanced filter option.
3. What to you mean by "when I select the filter option on the Data tab it filters all columns" ? It's the fact that it shows ComboBoxes on each field of your data? You know you can reset the whole filter by clicking on the Filter button to unfilter, then once again to enable the combo-boxes on each column. After checking a filter condition on a column, its drop-down arrow changes the colour, so you know that column is having a filter applied. I am creating this spreadsheet for my department and while I know how to filter and unfilter I just want one option for members of the department to use. I can leave it as filtering all if I have to but would prefer only one column, if possible.
0
SAW56Author Commented:
Just need to clarify, I know how to filter. I am actually creating this document for other members of the department and wanted the option to only filter one column (the one for supervisors). When I researched the fix it appears to indicate that I would need to modify the VB. I am not sure how to do that. Sorry, I thought I uploaded a picture of what I need but must have forgotten to upload it. I've also attached an example excel document.
Safety-Training-Tracking-example.xlsx
Filter-Example.gif
0
ArgentiCommented:
:)

So, You got it right. The actual Filter button is doing what it's supposed to do: placing combo-boxes over each column so you can check filters on them. However, you want to filter the entire data (spreadsheed), but you want to have one single combo-box (on the Supervisor column). I'm afraid it is not possible using the easy way :(

I suggest you to
1. create a cell (placed somewhere in the upper-left corner of your spreadsheet (maybe even in a "frozen" area),
2. assign a combo-box of values to it (out of your values in the Supervisor column) and
3. write some VB code to filter your spreadsheet data when you pick a value from that combo-box.
0
ArgentiCommented:
Or you can use this code to hide your auto-filter drop-down items on the columns you want:

http://blog.contextures.com/archives/2012/05/29/hide-arrows-in-excel-autofilter/

Good luck! :)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
SAW56Author Commented:
Both solutions worked. Thank you.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.