Row based excel file split

Hi,

I'm new to Macro and VBA. I'm looking a Macro or VBA regarding file split based on the row(s). The expected output should be

1. First Row or Row Header is a constant or common for each file.
2. Based on Cloumn A or B or C or anyother Column value, the file should be split along with the respective parellel data. Ex: If column A has
- Adam
- Brain
- Charlie
the output file name will be Adam then Brain then Charlie seperately with the data.
3. If my file has validation that also should reflect with the file which is split.
4. Macro or VBA should ask to the user to locate the path where the user wants to create the file. If the path is existed then the split file should create the same location.

Challenges
1. Everyday the Column A or B or C or etc will vary.
2. Everyday the validation will change..

Help me to Paste the Macro or VBA in my excel book with step by step procedure.

Note: Please excuse, I can't share the data though it is very sensitive. Hope the requirement is understandable. For further clarification do revert.

Thanks in advance.

Regards,
Vijay

'SHEET1 TO MANY WORKBOOKS
Here's a macro for parsing rows of data from one sheet to many workbooks named for the same values.

Sheet1 to Many Workbooks

My macro names the workbooks for values in the column PLUS today's date, you can take a stab at removing the date part...or leave it in, it's a good technique.

Please Login or Register  to view this content.