Create pdf and Email pdf

Copper Contributor

Hi guys,


I'm sort of new to VBA and was wondering if I can do the following - see attached picture for reference.


I have a sheet (Admin_Sheet) that I use to do calculations from other multiple sheets (VLOOKUP, SUMIFS, INDEX, MATCH, etc.).  It calculates Sales Data, Transactions, MTD, YTD, etc. based on one selection in a cell (STORE NAME) using a data validation of the STORE NAME in a couple of sheets.  What I would like to do is write a VBA (if possible) to:


  1. Select the next STORE NAME in the Validation Drop Down (+-130 Stores)
  2. Create a pdf document for each Store
  3. Email the pdf file to the recipient (email and Store Name linked on a different sheet)

Please assist if possible.



0 Replies