I've been trying to find a solution to this with no luck. I don't know all that much about VBA/macros so that is probably where the answer lies.
I have a spreadsheet with 2 sheets. The 1st sheet has some input data (person's name, address, etc.) and the 2nd sheet has a large (19 page) packet that has that data interspersed within the pages.
I want someone to be able to open this template, enter all the info needed on the 1st sheet, and hit print (printing on the 2nd sheet) without even needing to look at the 2nd sheet. I have all the data populating properly my only problem is printing.
One of the input data points is their marital status (Single or Married). If they are Single then I don't want pages 8 & 9 on the second sheet to print, otherwise all the pages can print.
Is there a way I can have a button the can click with a macro that prints those specific pages based on that cells value?
Thanks for any help and let me know if I didn't make any sense in my question (sometimes that happens to me)!