I need to save the file as a new name.
The first part of the filename is a customer's name and the second part of it is my file # reference.
It looks like this:
CUSTOMER NAME 1234
I need it to keep the "CUSTOMER NAME" and change the file number at the end (will always be 4 digits).
The file number is always in N3. but the customer name moves from cell to cell based on the document (sheets) within the workbook.
Thank you for your help!
Bookmarks