Guys, please see the attached and thank you for your help.
I have a sheet that imports hours and date to a spreadsheet similar to the attached. The imported info reflects the current total hours worked in the week.
After I import the file with the current weekly hours, I manually enter the current hours on the sheet that reflects the previous day that were worked. The formula does the math to give the result of the hours worked of the previous day. The imported info is a current and increasing weekly total from day to day.
Is there a code that would compare the dates then enter the respective daily hours on the cell that reflects the hours of the stipulated date?
Thank you, Robert