Hi everyone, I am new to this side of excel. I have no real knowledge of the coding required to use this side of excel but I know its powerful and can do what I'm after, I just need some help if at all possible. I am working on a spreadsheet for work as an electronic shift log and I am looking to add a command button to basically save and publish the active sheet as a pdf to SharePoint and email to a group defined in a group of cells in the workbook on a second sheet without saving any changes to the original workbook. I would like to be able to pull from multiple cells for the file name. If there is anyone that could help or at least point me in the right direction of where to look for the information, it would be much appreciated. I have played with bits and pieces of what I am trying to do but could never get anything to work right so I got frustrated and scrapped it all.