is there anyway wer i can create a macro that automatically uses the save as function and saves the file in the name of a particular cell??

this is because i have created a format wer i enter the scores and after the end of the contest i want the scores to be saved but not on the original file.