I have a workbook containing 50+ invoice sheets, and that number is likely to increase. There are also a dozen or so tabs with data tables and/or calculations. Each invoice sheet is linked to different data tables so all I need do is select dates on my home page, and all the invoices are ready to print. Currently, I simply select the first tab, scroll to the last tab, hold shift, and select the last one, then print active tabs, and I'm done. Every time I do that, I wonder if there's a way to place a quick-print button on my home page. In other words, once I get all my data populated and calculated, I'd like to go to my home page, select the correct moth, and then select "Print All" to automatically pdf all the invoices.
Can anyone point me in the right direction to do this?
Thanks.
Bookmarks