This should be pretty simple and I have seen examples floating around, but I'm not great at combining macros and have had a lot of failures. My hopes are to print the excel file as a PDF to a certain file path as "CompanyName_Date," print the file to a certain printer, AND clear out certain spots OR open a fresh copy from the template when I enter a command in the first column of sheet 2. That first column of sheet 2 will just be raw data entered in, so it needs to look for that command, something like "Save and Print" every time a new value is added to the column. I appreciate any help you have in piecing this together, it would be invaluable to my project!
EDIT: Added attached example.
Bookmarks