Forum Discussion
How to generate a PDF for each value in a filter?
I have a spreadsheet with a "location" column. I'd like to generate a PDF for each location, with the PDF compiling every row that has that as the location. That's something that seems really easy to...
I can't help you with VBA and macros.
Depending on how many locations there are, and depending on whether or not you have the most current version of Excel, it would be fairly easy to create the content for the location specific printouts.
See if you can enter the FILTER function and have Excel prompt you for the array to be filtered and criteria to be used....if so, that function will extract the data. Then it's a matter of recording the steps to run through the list of locations, and creating a loop to do that, print to PDF and go to the next....
If there are only a few, it wouldn't be hard to just do the saving to PDF manually.