Excel Magic Trick #126: Macro: Advanced Filter Extract Text

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.

Category:

Science & Technology

Tags:

• Excel
• Advanced
• Filter
• TRUE
• FALSE
• FORMULA
• Text
• Extract
• Macro
• Button
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[daggerdotmil]

HI this tutorial was great i used this creating a library for forms but i was wondering is there anyway it also can carry the Hyperlink on the text I hyperlinked the text but when advance filter copies it to new location it is not hyperlinked

[ExcelIsFun]

I do not know. I am not very good with hand written VBA code, but I am sure it can be done. Try THE best Excel question site:

mrexcel[dot]com/forum

[emailuznow]

Hi Mike, how can i extract all the 3 columns instead of just the title column?

If i select all 3 columns it works fine only the first time when the macro is run however when you run the macro again it only displays the first column and not extract all 3.

[ExcelIsFun]

How about not doing it with a Macro, but instead just using Advanced Filter. I am not sure what the problem is and I am very busy with work right now and sick at the same time...

[stacybsimmons]

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.

[ExcelIsFun]

Usually when a query results in zero records extracted, it is because of:

1) There are no records that match the criteria

or

2) The criteria is not entered correctly (such as an extra space that makes that criteria not match the elements in the table - the reverse can be true also), or the formula is not setup correctly.

Beyond that, I have no idea without seeing the file. Since I do not do consulting, try THE best Excel site for questions:

mrexcel[dot]com

[ExcelIsFun]

If you do post to:

mrexcel[dot]com

Do not reference this video. But instead explain your problem and the data setup and what you have attempted in complete detail. If you ask a question clearly, you can usually get a reply from someone within 15 minutes.

[MrStrewman]

just wanted to say thanks for quebec. Very usefull. Can u do more for humain ressources and dashboard please. Thanks for sharing your knowleadge

[ugbari]

brilliant work

[lalaalala1]

Hi I have a question here,

I successfully done something similar to what was shown in this tutorial. However, on top of this, let's say if i want to directly hyperlink each title to their respective videos on my hard disk, the link only works for the full list, but not for the filtered list. In short, the hyperlinking is not retained. How can i solve this problem such that my filtered results STILL has a working hyperlink?