Hi Kal,
The code below will change the formula's on your Report sheet (Change sheet name in code to match yours if necessary) to values when you open your workbook.
Here is the code:
Private Sub Workbook_Open()
Sheets("Report").Select 'Change the sheet name to match yours
For Each cell In Range("A4:A" & Range("A4").End(xlDown).Row)
If cell.Value = Date Then
cell.Offset(0, 1).Value = cell.Offset(0, 1).Value
cell.Offset(0, 2).Value = cell.Offset(0, 2).Value
cell.Offset(0, 3).Value = cell.Offset(0, 3).Value
End If
Next cell
End Sub
To use the code, press Alt+F11, double-click ThisWorkbook on the left side and paste the code in the big white field. Save and close your workbook, re-open to see the result of the code.
Here is a picture to guide you:
Best regards,
Trowa