Results 1 to 3 of 3

Thread: Saving exported spreadsheet and naming the file based on a cell value VBA HELP!!!

  1. #1

    Saving exported spreadsheet and naming the file based on a cell value VBA HELP!!!



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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!

  2. #2
    Bumpppping..

  3. #3
    Filename = Left(Range("B3"), 1) & "_Results"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •