Excel macro to Automatically generate the data and save file

[Kausik]

Hi All,

I have a Excel macro (Preliminary) which filters and get the data from another workbook (Blue Print Data Dump) and save as the whole file in a path I have mentioned in Preliminary Excel Macro file

Now I need the macro to do the same for the whole list in the specific folder by looping it. I mean it should automatically generate the data and save the file as per the mentioned naming convention for all the codes.

Can someone help me?

Current file has been modified with the help of John from here. Thanks @John Jairo V for your support

 

[AlanSidman]

crosspost: https://www.ozgrid.com/forum/forum/...generate-the-copy-of-main-excel-and-save-file

and

http://www.vbaexpress.com/forum/sho...Automatically-generate-the-data-and-save-file

 

[vletm]

Kausik
You have already asked once to read Site Rules:
https://chandoo.org/forum/threads/needed-help-in-running-the-macro.39846/#post-238390

You commented that: Thank You

Did You read those Site Rules?

• Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
• If you do cross-post, please put that in your post.
• Also if you have cross-posted and get an answer elsewhere, have the courtesy of posting the answer here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.