Excel VBA Macro: Autofilter, Copy, Paste to New Sheet and Save to Specified Folder (Dynamic Range)

[@YT2007XYZ]

This was one of the clearest and easiest to follow tutorials on this subject that I’ve seen. Thank you!! I hope I can be successful at making a few minor changes to what data is selected and where it’s saved …. (only copying a few of the rows and columns to another worksheet within the same workbook, and using an input box to allow the user to select that specific range which gets copied). I’ll be checking out your other videos and subscribing. Keep up the nice work!!

[@greggowaffles]

So glad to hear that! Thanks for the feedback!! I’ll definitely include that scenario in a future video

[@YT2007XYZ]

@@greggowaffles I've been retired for over 12 years and you sound like you might be in your mid-20's???.... I was curious what route you took to be this proficient in VBA? I used excel a lot in business but never had a real understanding of VBA and looking back I know that it would have made my life so much easier. You may have reasons why you don't post any info in the ABOUT area, but I'm guessing with your knowledge of Excel and VBA you may be losing opportunities for employment, unless you just do this for fun. Just saying.. Again thanks for the videos!

[@greggowaffles]

No problem! I’m actually in my early 30s, and I taught myself VBA to make my job as a financial analyst easier. I’m a data analyst now. I never made an effort to update that section, but I have no reason not to. That’s a really good point. I’ll update that today. Thanks a lot!

[@gaybarile4232]

Thank you very much for this tutorial. I am new to VBA and I find your videos very helpful.

[@greggowaffles]

You’re welcome. So glad to hear that!

[@andrepkownage]

I really need your help, is it possible to edit your marco to be able to save every fliter region information instead of having to click in one by one?

[@kashmoney1]

Hey - are you able to save the same workbook with the macros? This is amazing - really helpful! I need your guidance where I have a bunch of pivot tables that need to be refreshed before saving the file name, is that possible in your macro at the end? Thanks a lot!!!

[@KenDC-b8v]

Hi Greg, Thanks for this tutorial. And could you help me with the code instead of filtering it one by one is there a possible way to run all the region?

[@RayRay-y1j]

Hey this is great stuff and excellent explained! I do have a questions. How to modify the code to filter rows based on dates?

[@coolguy12288]

Great Video! One question, how do I make the name of the sheet the same as the name of the file though? For example in your video when you save each file, as you automate the name of that file, is there a similar way to automate the name of the sheet in the bottom left corner of the excel file too?

[@adamsreef]

Hello greg. I need help on how to auto filter, copy and save to new workbook if there is an the additonal worksheet wherein i have there a simple pivot table for summary. So basically i have the first sheet as raw data and the second worksheet as with pivot table summary. Hope you can see this.

[@rc2204]

is there a way after you filter on the region to save that to its own tab for each instance w/in the same workbook ? thanks.

[@Lyriks_]

Hello i'm digging your tutorials ! Could you do more on pdf automation ?

[@paeng0225]

I am having problem on the Set raw details It has debu on it

[@EatGyroSandwiches]

Hi. Subscriber here. I’ve been using this macro and it’s working great! My list is growing. How can I get the macro to auto loop down the list so I don’t have to run the macro for each item in the list?

[@greggowaffles]

You can add another tab that has your list. Use another count_row variable to get the length of the list and then use a for loop that starts above the “‘filter data on Raw Data tab” line and ends at the bottom of the “ActiveWorkbook.Close” line. You’ll also want to update the region variable inside of the loop each time. Hope that helps! I’ll make a video on that and post it in the next few days

[@EatGyroSandwiches]

@@greggowaffles thank you I will watch the video! I appreciate this a ton!!

[@greggowaffles]

No problem at all! I’ll let you know when I’ve uploaded it

[@KenDC-b8v]

​@@EatGyroSandwiches Hi same here do you have the workaround on this? Thank you!