I have a template that I use to prepare quotes, but when I am busy or have 2 or more clients I am working with I cannot open a second template without going through several steps (Save as, select folder, rename).
I need a code that will automatically rename the file once cell c3 is entered (name of client) and auto save in a predetermined folder. C:\Desktop\Prospectives
Any ideas?
I need a code that will automatically rename the file once cell c3 is entered (name of client) and auto save in a predetermined folder. C:\Desktop\Prospectives
Any ideas?