I am proficient with excel macro/VBA development, I can write the macro to split main file by 100 items as specified, if you are interested feel free to message me, I am available to start your project immediately, looking forward to chat further and work on your project