I have to copied and pasted two macros to my spreadsheet attached to control buttons.
One control button "save as" the active workbook to a specific folder on my shared drive under a name specified by two cells on the spreadsheet. The workbook is an "end of shift" report for supervisors and will be saved to the folder 3 times a day.
The other button copies the spreadsheet into a PDF and attaches it to an email.
I copied these from some videos I watched and made the appropriate adjustments to fit my spreadsheet. I in no way know how to write a macro.
I realized after getting done it would be better to attach the newly saved file to the email instead of a PDF because then the next supervisor can just take the already filled out end of shift report and edit any changes that occurred on their shift and use the "save as" control button again to create a new workbook for their shift.
I don't know if I make edits to the "save as" control button to just have it also attach the newly created workbook to an email, or
If I edit the email control button to grab the newly saved workbook from the folder on the shared drive and send it.
The two macros I used will be pasted below. I would greatly appreciate any help from the experts here.
Thank you!
-----------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------
Bookmarks