Copy, paste, change name of file.

[cpostell]

I am working on a quote tracking program in excel and would like to streamline the quoting process. I have an office form my sales staff can fill in which populates an excel table for me to see the information. Within the table I have formulas to do many things and one is to compile a lot of the information to make a file name. I have a quote template in another excel right now we copy, past, and rename to the file name we would like. I am looking to see if there is a process through VBA or power automate to complete this function. My table has the file paths along with the name in it. One of my formulas has a hyperlink imbedded so we can open the PDF version of the quote once completed to speed up the follow up process of quotes. There are approximately 10 different file locations the quote template will be saved to based on the row in the table and who the sales person is. The file name will always be unique. In the images you will see the location is unique based on the associate. I also showed an example of a file name.