I am looking to have a range of cells (“H5:H25”) change to match the value of “H4” if it says “Absent” and remain its current data if false. I was able to run code which changes the range to a specified value if false but I am hoping I cane have it leave the cell as is. I also tried using an activex checkbox but still cannot get it to do what I am hoping is possible.

this action will need to be done for approximately 25 different columns. Can someone help me?