I am not new to VBA but for some reason I can't seem to wrap my brain around this problem . I have a macro to clear out a sheet and prefill the info to ready it for the next month. So here is the basic concept: A1:A31 is the day of the month. B1:31 is either blank ("") or "Closed" for whether the branch is open or closed on a specific date (this is prefilled using formulas on the sheet). C1:C31 is the amount of money we made (GP) on that day (the employee fills in the amount). For the "Closed" days I want the macro to enter in a "0" in the corresponding cell in column "C".

Should I do a loop or define each line to look in the adjacent cell and fill in the value?