I am trying to make a code that will copy a specific worksheet to another workbook that is not open and rename the sheet once copies.
Starting with workbook 'Master Tracking' when I run my macro I want it to copy sheet 'Notify Clinic' to workbook 'Consult Notifications' located at 'C:\Spreadsheets'. The target workbook would not be open when the macro is ran, and would ideally save and be closed after the sheet is pasted in. I also want it to rename the sheet in the target workbook to reflect that days date.
Bookmarks