I have a workbook template, I have managed to create a button that prints only the rows that contain information, I would like to be able to;
a button that saves the workbook as a macro enabled workbook to the local my docs folder with the file name 'Cell B21 - Cell B20 - current date & Time'
a button that publishes only the first worksheet, omitting any unfilled rows as above, same file-name as above, but as a .PDF file, into a specific shared network folder.
I can e-mail you the workbook so you can see what I mean.
Bookmarks