title: Automatically name a file based on cell data when saving a spreadsheet?
body: <p>I have an .xltm template spreadsheet that I'm wondering if I can get a macro to populate the "save as" file name based on cell data, is this possible?</p>
  
  <p>There are over 50 people who will have this spreadsheet, it's more of a form, and we are trying to figure out a way to keep the filenames uniform. I know there is the ThisWorkbook.BeforeSave, but I'm not really having any luck there. I just need it to make a file named something like <code>$A$1 R $B$1 T $B$3.xlsx</code></p>
  
  <p>Any ideas on how to do this?</p>