To split one excel file (one worksheet) into different excel files (different workbooks) by column value.
Two methods are provided. One is to do the job with python, one with VBA macros.
Python:
Libraries used in this file are:
pandas, pathlib, argparse
In the end you will be able to run the script via the command line instead of adjusting the code in python file thanks to argparse.
Credits, thank you for your tutorials:
VBA Macro: Split Excel Worksheet into Multiple Worksheets Based on Column Value
https://www.youtube.com/watch?v=2isx7rIYpz4
Argparse Basics - How I run my scripts via the Command Line
https://www.youtube.com/watch?v=FbEJN8FsJ9U