Filter Cells using Checkboxes

Hi,
Give the attached a viewing, rather than developing a nightmare.
Put your films in column 'A' (A2 downwards ) and your genres as the table headers (B1, C1, etc.,)
The table expands automatically with additions - ensure there are no blank rows or extra unused columns or rows beyond the table.
put 'x' in appropriate intersecting cells (i think that is obvious) - not a single checkboxe to add.
torachan.

Thanks, but this doesn't seem to do what I want. The idea is to be able to filter out films that don't meet the qualifications (i.e., the boxes I check).

Have you tried it, thats precisely what it does.

Sorry, I'm using an older version of Excel (2007). I never use any of the Office programs so that's why it's not current. The file you attached still opens, but it removes some of the content (probably what controls the filter feature), so on my end, I don't see any way of filtering it. What version of Excel do I need to open this correctly? Or is there a way to make the file work with my version? Thanks.

It was produced using Excel 2010.
In the VBA editor goto Tools > References - are there any shown as missing.
Most likely problem - (Microsoft Excel 12.0 Object Library) this is used by 2007 however (Microsoft Excel 14.0 Object Library) is used by 2010.
Whatever the difference within I do not know.
torachan.

The VBA editor button is greyed out and unclickable. Is it possible to save the spreadsheet you gave me in a format that 2007 can recognize?

Give the attached file a try.
It may require you to allow macros to run.
The VBA has been passed through Norton and has no viruses.
torachan.

HELP !!! Please.
Any one with Excel 2007 and 2010 could you please assist.
If you could open either or both of the files please and comment.
I am at a loss why the O.P. is experiencing difficulty as I can not find anything wrong with the files when I download them back to my second computer.
torachan.

This works! The only thing is, some of the cells turn red when I double click to make selections. For instance, if I double click the "foreign" tag for Masked Zombies, that cell turns red when it has an * in it. Or if I double click "Italian" for Andromedia Strain, the cell next to it under "foreign" turns red (even though that cell is empty). It seems only the cells under the "foreign" tag turn red. I just double clicked every cell and the entire "foreign" column is now red. I attached the file. Does this happen on your end as well? It's not a huge deal, the sheet is still functional. But it would be nice if they didn't change color.

Thank you! This is great!

So I ended up with way more tags than I thought I would and it’s making the table hard to read. To fix this, here is what I’d like: When a filter is applied, I want it to only display the columns where a * appears for any of the displayed films. I attached my current sheet showing an example (the file size is over the 1MB limit for xlsm files so I had to zip it.) As you can see, when I check the “1960s” and “Foreign” tags and apply the filter, the only two films that are displayed are “100 Cries Of Terror” and “A Study In Terror”. However, the sheet shows all of the columns even though most of them don’t have a *. The only columns that have a * for either of these two films are the following:
1960s
Foreign
Mexican
British/UK
One Thumb
OK
B&W
Thriller
Mystery
Jack The Ripper

Is there a way to only display these columns rather than displaying all of the columns since most of them lack an * and don't apply to these two films? This would make the table much easier to read. And obviously, I would want the sheet to do this for any filter that is applied; what I gave above is just an example. Again, thank you so much for all the help! I really appreciate it!

Thank you for all your hard work! This is definitely on the right track, but this seems to eliminate too much. It looks like the filter eliminates all columns except for the ones that are checked. Continuing to use the example I gave above, if I check the “1960s” and “Foreign” tags and apply the filter, the only two films that are displayed are “100 Cries Of Terror” and “A Study In Terror” (which is correct). The problem is that the only columns that are displayed are the two that are checked: “1960s” and “Foreign”. But all of these tags apply to at least one of those two films:
1960s
Foreign
Mexican
British/UK
One Thumb
OK
B&W
Thriller
Mystery
Jack The Ripper

So all of those columns should be visible when the filter is applied, not just the two that were checked. I only want the completely empty columns to be removed. That is, columns where no * appears for any of the films that are displayed when the filter is applied.

Another kind of odd thing that is happening, if I check "USA" and "One Thumb", I get this (see attached image). The "One Thumb" tag text is gone, but the *s still appear below it. But in the next column, "Two Thumbs" appears even though that tag wasn't checked. I thought it might have something to do with the "format control/move or size with cells" option, but it appears all the check boxes are set to "move but don't size" so that must not be it.

This does exactly what I want it to do! The original request was to filter out any movies that don't satisfy all of the checks. So if I check “1960s” and “Foreign” I want it to only display films that satisfy both of those conditions. But once those films are displayed, I still want to see all of the tags that apply to these two films (regardless of if I specifically checked those tags). So once it displays the two films “100 Cries Of Terror” and “A Study In Terror”, I can now also see all the other tags that apply to those films. This is exactly what I want! Thank you!

The "One Thumb" and "Two Thumb" tag text error that I mentioned in my last post is still happening though. Here are some examples (I attached the sheet for each example with the checks pre-selected)
Example 1: If I check the "One Thumb" tag, the tag text is gone, but the *s still appear below it as they should.
Example 2: If I check the "Two Thumbs" tag, the tag text is gone, but the *s still appear below it as they should.
Example 3: If I check the "Three Thumbs" tag, the tag text is there and the the *s still appear below it as they should, but there is a blank column to the left. This blank column appears a lot regardless of what tag is checked.

Other issues:
In tag columns: There are two "Ed Wood" tags and two "Tobe Hooper" tags.
In tag rows: There is double/overlaying text for the "Scooby Doo", "Creepy Kid", and "Clown" tags.

I didn't delete any of these duplicates because I didn't want to mess anything up! I didn't know if it mattered which one I deleted, etc. Once these issues are resolved, I think that should be it! Thank you so much for your patience, I know there has been a lot involved here... But I really do appreciate it!

Thank you! #1 and #3 work. But #2 just selects cell A1, it doesn't change the scroll position of the sheet. This is because the first two rows are set to always be displayed since those rows have the tags and apply/clear filter buttons. So that cell is always being displayed anyway. Is there a way to make the sheet scroll all the way to the top and to the left when the apply filter button is pressed? Thanks again.