We generate reports that hold details for multiple practices all in one sheet, which is nice and convenient for me as I can run a pivot table off it and analyse any number of practices and services as I see fit. Unfortunately this report also needs to go out to the individual practices and without a sharing agreement in place, the reports need to be cut into smaller, single practice chunks, so that practices can see their own data and not that of their neighbours. If you are going to do that task manually, by filtering and then saving each as an individual PDF, you will very quickly come to hate the tedium of your job and quit. This is where a macro comes in handy and saves your sanity. I have a list of all my unique practice codes in the tab PRACTICE, this could be a pivot table or just a fixed list. I want my macro to work through this list, filtering the main report in tab WEST to show each individual practice and saving a PDF copy as it goes along.
The sheet in a newly created folder in the same path as the workbook with this macro. Note: Working in Excel 97-2013 If you use Excel 2007-2013 it will check the file format and will save the new files in the same format. Only if it is a xlsm file and there is no code in the sheet module it will save it as xlsx.
![Itunes Itunes](http://c1.novapdf.com/uploads/novapdf_en/media_items/print-multiple-excel.640.684.s.png)
The macro below does this.