May 30th, 2010
See how to create a macro that will do an Advanced Filter Movie Title Extract for a Movie Database. See how to create the TRUE FALSE formula for advanced filter before creating a Macro and then adding the Macro to a Form Command button.
Tags:
The quick and dirty way to fix it, is to delete the Macro (Alt + F8, then highlight macro, then hit delete button), then create a new Macro. The advantage is then you don’t have to edit the code in the VBA editor.
Hi,
as you instructed to mond118 i selected the all 3 rows (B-D) and did it. first time it happens. there after when i run the macro only the first column changes. other remain as it is.
but when i copy it to a seperate location ( copy to box) it again works fine..
Dear stacybsimmons,
EXCELlent!!!!!
–excelisfun
Hi,
Thanks. I figured out what I was doing wrong. I left the $ sign out of the Isnumber(search(f12. Thanks again! Your tips are GREAT!!
Dear stacybsimmons,
Any time you get a zero or blank answer from Advanced Filter, it means that no records match. So eitherno records match or the criteria is not correct.
–excelisfun
Hi,
I really like this tip. I’m trying this with excel 2003.
I have setup a spreadsheet similar to the one in the video. When I do the Data Advance Filter the only thing that outputs is the column heading (i.e. Title) No records are output. Any ideas about what I might be doing wrong?
Thanks.
Dear PrincessWithSkills,
I am glad that it is useful for you!
–excelisfun
Dear mond118,
Yes, instead of just the B column, use the B - D columnns for the “List range” in the Advamced Filter dialog box.
–excelisfun
sir..
can u extract all 3 columns together? the video only extracted the TITLe column.. not including the 2 other column..
Dear mutony9,
Excel 2007 rules over any other version for many reasons. On reason in the Filtering feature that has automatic today, tomoorw and yesterday. If you wanted to do it with a formula like in this video and you had date column, you could use the formula =Today+A1, then put -1 in A1 for yesterady, 0 for today and 1 for tomorrow. You could create a column with Date from your separate column if you used the DATE function.
–excelisfun
Hi ExcelisFun,
In my excel data base I have many columns. 3 of which represent the current date. There is a column “d” for day, “m” for month, “y” for year. Each of these columns has an auto filter so I can select which day,month,or year to view. Can I make a button that, when pressed, will filter me the entries for the current date (and to toggle 1 day forward if possible)? Any existing lessons pointing me in this direction would be greatly appreciated!
This one is quite useful, thanks!