I have a cash flow spreadsheet that automatically selects different assets and data from a data validation drop down list. It's one self contained workbook with multiple sheets. I only need one workbook to create the cash flow easily, however I have to print a copy of each possible cash flow based on a combination of two variables. It would be great if I could automatically create the pdf's for all of the combinations. Printing them then would be easy by selecting them all in the explorer window and right clicking for the print option. Do I need VBA for this? Can I record it? Can you help?
Bookmarks