Hi All
This is my first post so bear with me! Great forum, has been extremely usefull. I am a real VBA novice but pleased with what I've been able to create so far with help from clever people here.
I have a macro set up that splits one worksheet into mutiple files depending on a value in a particular column. At the moment I have to go into the code and amend the desired file path and then the desired file name of the new files before running the macro to split the files. What I would like to do is incorporate an input box so that when the macro is run from a button it asks where you want them saving and what to call them.
I already have an input box that asks what column I want to split the data by. Just not sure how to apply this for saving. I want others with little or no VBA knowledge to be able to use the file without having to amend the code. Any help would be much appreciated
This is my first post so bear with me! Great forum, has been extremely usefull. I am a real VBA novice but pleased with what I've been able to create so far with help from clever people here.
I have a macro set up that splits one worksheet into mutiple files depending on a value in a particular column. At the moment I have to go into the code and amend the desired file path and then the desired file name of the new files before running the macro to split the files. What I would like to do is incorporate an input box so that when the macro is run from a button it asks where you want them saving and what to call them.
I already have an input box that asks what column I want to split the data by. Just not sure how to apply this for saving. I want others with little or no VBA knowledge to be able to use the file without having to amend the code. Any help would be much appreciated
Thank you Dave, love it!!! Works perfectly. Thank you for your time, much appreciated!
