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.
The following example demonstrates this in Excel 2007, Excel 2013, and Excel 2016. The code will open the first sheet and display the first row of the first column of the second sheet. You can also click the “Print” icon in the top right corner to generate a PDF as well (these samples do not generate the full page of a PDF). See the next page for more examples. Create a Loop Macro Start by opening the example sheet using the following macro: =IF(SLOWER(F1:F10),1,ERROR(A1:A11,1,0)) The macro performs the following steps: It determines if every row in the first sheet is the lowest number (1). It then adds 1 to each row. The macro then returns if that calculation is true. Then it adds 1 to every row again. The macro then returns if the calculation is also true. If SLOWER(F1:F10) returns 1, we have a calculation error. However, if the calculation of our macro is.