I’d like to make a macro that when run saves the current workbook to a new file in a certain location with a name that matches the current contents of a certain cell, A3 for instance. After data entry the clerk could run the macro and the file would be saved with the correct name. I’ve tried to record such a macro, but it saves the file with the same name even after I change that cell.
