Hello,
I've created an export button in excel and I would like to save this exported spreadsheet based on a cell value. For example, when i export the spreadsheet out, I want the macro to read cell B3 to see if the name of the person starts with E or an F. if Cell B3 has a name of the person Eric which starts with an "E", then save the file as "E_Results" else save it as "F_Results" if the name starts with an F (frank).
Can anyone help me out?
thanks!