Hello,
I have a large workbook (27000 KB) that I'm trying to prevent people from having to open. On "Sheet1" I have a page that has a dropdown on A1, the dropdown is a list of 40 names from "Sheet2" A$1:A$40. The goal is to create a PDF from "Sheet1" cells A1:Z50 and sent to the email address located on cell A3. I want it to repeat this process until all 40 names have completed. Please let me know if any further details are needed.
Appreciate and help on this.
Thanks
JAnders
I have a large workbook (27000 KB) that I'm trying to prevent people from having to open. On "Sheet1" I have a page that has a dropdown on A1, the dropdown is a list of 40 names from "Sheet2" A$1:A$40. The goal is to create a PDF from "Sheet1" cells A1:Z50 and sent to the email address located on cell A3. I want it to repeat this process until all 40 names have completed. Please let me know if any further details are needed.
Appreciate and help on this.
Thanks
JAnders