Hi There,
As an Excel and VBA Developer, i can do this according to your Condition and i can create a code accordingly so that you can handle easily. I have also worked this type of similar project and i have more than 3 years experienced in this profile. If you are interested we can discuss on it, i am available 24/7 for the support/project.
Thanks,
Daksh Mahaur
Excel and VBA Developer