Excel macro to Automatically generate the data and save file

[kausikmohan]

Hi All,


I have a Excel macro which filters and get the data from another workbook and save as the file in a path I have mentioned.


Now I need the macro to do the same for the whole list in the specific folder. 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?

[p45cal]

cross posted at 2 or 3 other locations.

[Aussiebear]

Please do not cross post