VBA code to Subtract values in Column F with Column E if found non-blank

Originally Posted by arlu1201

So you want the code to be in a separate workbook? Do you want the code to open the file containing the Admin worksheet?

Hi arlu1201,

I want the code to be written in the Workbook_Open() of Admin.xlsm in which I will manually open only at the end of each week to see the working hours of staff.