I'm trying to record a marco to copy a cell from sheet 1 into sheet 2 which then populates sheet 2 with data and updates a plot graph 1. I've then moved to graph 1 and exported it as a pdf. I've been copying the name for this pdf from sheet 1. The problem I have is that when I re-run the macro it updates the graph accurately but saves it with the same name as the previous pdf exported overwriting it. How do I get it to always be a new pdf?
Solved by O. Q. in 11 mins