I have the below code that is currently looking up specific cells
FindDate As Date with the Value being "E8" however, this is for Monday only. I want to be able to find all of the days and input their values into the required sheet.
Tuesday = I8
Wednesday = M8
Thursday = Q8
Friday = U8...