Yes, you can create an macro to run iteration based on change in a cell value (loop), and save the file/sheet as pdf at the end of each loop.
You can also create the macro in the macro menu, but it is a bit cumbersome: There you'll find one, and only one, macro: the Iteration macro. There is no save button, but a few things can be set in the macro menu. First, you have two switches called Save and Loop. I set Save to False — don't let this macro run on my computer. Second, you have to set a bit in the loop variable called the number of iterations. You do this by using the % operator. For the value of 1: %(1). Then you set the number to 1, and the number you used can be anything between -1 and 1. For example, %(2-3). The other thing I set in the macro is the output column color. This is just the name of the column: I use this macro in the “File” column. I usually just use the.