What I'm attempting to do is create a macro to save a document so that the document will be saved under a name that corresponds to a cell. I have tried recording the macro, but it only allows me to save it to a specific directory with a spec name. On my worksheet I have a drop down menu to select the a specified number. When i hit the "save" button, I'm wanting it to save as a file name that is in the cell from the drop down menu. I've posted a pic to help explain. Sorry if terminology is incorrect.
excelhelp.jpg