Forum Discussion
Excel / VBA - filter data and save in new file
Hi All, I need some help with Excel / VBA. I have a dataset with a column with different categories and want to filter on each category and save the filtered data in a separate file. This way th...
Hi Hans,
Thanks for this. The change in code does not yield the desired outcome. I still have the problem. Did you try the code yourself with the change? If so, please can you let me have the full file?
Thanks,
Naveen
Yes, I tested the code. Here is my test workbook with some dummy data. The macro produced multiple files: