i want VBA code for column C to be auto filled cells with the word "Absent" if any cell is left blank.