I am proficient with excel macro/VBA development, I have write the macro per your specification, if you are interested feel free to message me so we can go over what needs to be done in detail, looking forward to provide a workaround solution and work on your project