Looking for code to save a file as a specific file name. For example, want file name to always contain the work DECO, followed by a space, followed by a job number.
Such as:
DECO 291131.xlsm
The job number is found in cell L5 in worksheet LOAD LIST. I have multiple worksheets.
Thank you!
Bookmarks