automating repetitive tasks

Stanley

Thank you so much for the answer, that is an intellegent way to do it.
I can't upload the real workbook for priivacy reasons but have attached an example close to what I am working with....

If its possible to make a Macro for this I'd be most appreciative,


Thank you!