I have a Dashboard that displays graph and text dynamically filled upon selection of DataValidation list in cell A1 (on Dashboard).
So I need to create a macro that will cycle through all entries in the dropdown, creating a new .xlsx with the same formatting for the user.
User will activate macro and be prompted for path/folder in which they would like to store their files. Each dashboard would be a uniquely named .xlsx (ideally the file name would contain the name which is the value selected from the dropdown in the Dashboard.
I have a VERY beginning understanding of vba and haven't written loop code nor done much other than record a macro and tweak the code to my situation. I've seen a few other threads on this topic but couldn't make sense of any of it, so please, if anyone can help, please know that I'm a beginner here. Thank you VERY much for any and all help!
So I need to create a macro that will cycle through all entries in the dropdown, creating a new .xlsx with the same formatting for the user.
User will activate macro and be prompted for path/folder in which they would like to store their files. Each dashboard would be a uniquely named .xlsx (ideally the file name would contain the name which is the value selected from the dropdown in the Dashboard.
I have a VERY beginning understanding of vba and haven't written loop code nor done much other than record a macro and tweak the code to my situation. I've seen a few other threads on this topic but couldn't make sense of any of it, so please, if anyone can help, please know that I'm a beginner here. Thank you VERY much for any and all help!