Hello, I was hoping to get some help creating a macro button to copy/create and rename a PowerPoint template, and hyperlink it in my worksheet so the individual user wouldn't have to do it. This is my first time using macros. I typically only use IF functions in Excel. Here's what I would like the macro button in L3 to do:

Example2.xlsx

1. Copy "C:\template.pptx"
2. Rename copied template.pptx to the values in C3 D3 F3 - J3. Example from attachment (1234 A001 Sample Product 1 - 2000.pptx)
3. Create a hyperlink to the new file (C:\1234 A001 Sample Product 1 - 2000.pptx) in A3, and display as "Link"

Is there an easy way to add this button to each row without manually re-writing the row number in the macro?

Is there a way to hide the button until values are added to C D F and J? It would look ugly having a column of 1000+ buttons when I only have 200+ rows of data at the moment.

Thank you!