I have a macro that splits data into separate sheets within the workbook based on a specific field. I now need to split into separate workbooks based on that field instead of into separate sheets.
Many thanks to Ron deBruin for the original macro and Alphafrog for the assistance in customizing it for my needs.
I tried searching the forum for possible solutions, but couldn't come up with the right keywords to narrow the search down from the 1000+ results.
Can someone tell me how to modify this and/or point me to a macro that is already set up to do this?
Thanks in advance!