Record and Edit an Excel Advanced Filter Macro
HTML-код
- Опубликовано: 21 окт 2024
- Use an Excel Advanced Filter to copy specific items from a list, to a new location.
The extracted data will not update automatically, so record the steps as you use the Advanced Filter feature.
Then, edit the recorded macro, to make it flexible, in case the source data range changes.
See the steps in this short Excel video tutorial.
For more details, and an Excel workbook, go to my Contextures site.
www.contextures...
SO Helpful, I was using dynamic formulas to auto extract, and with 20,000 records it was a big slow workbook! Now its very lean and quick, thank you so much!
Hey Guys i found the solution to error Run time error 40036 (application defined or object defined error)
I have given the macro name TopOrders and also the sheet name is TopOrders.
I have changed the name of macro and tried again. Now its working for me..
Thank you again for sharing this video.
i followed the steps im getting error runtime error 1004 the extract range has a missing or invalid name
Sheets("PartsData").Range("B4").CurrentRegion.AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Sheets( _
"LookupLists").Range("G1:G2"), CopyToRange:=Sheets("PartsData").Range("N4:R4"), Unique:=False
What if, in the macro, I want it to filter for more than one value. For instance, I have a list containing data for 62 cities (criterion) and need data copied weekly from each city. How could I copy the advanced filter in the macro for those 62 criterion. Each time I've tried, the macro records all my scrolling through the data and it's tough to find which part of the HTML is the filter. I want to delete the excess as Contextures did in the video. PS: I'm an excel newbie and an HTML dummy. Any help would be greatly appreciated.
Thank you for the video..Its working fine if we record it... after making changes like current region.. adding the sheet name TopOrders, the code is giving error like Run time error 40036 application defined or object defined error.
Any help on this will be great.
Thank you.
after I change type in CurrentRegion and I got everything like yours but there's this error 1004 that says my extract file region is wrong or something like that. don't know what to do
Hi there
if are using share folder. Any ways we could find out last person edit?
Hi, Could you do one for google spreadsheets
Chrystal clear, as always ;) Thx, Debra ;)
Very good video. Keep it up.
fantastic. god bless you
Thanks San Diegan
Thanks very much, been banging my head looking at forums etc++++++++++++++++++:-)
Great!
You are good but need to slow down a little :)