Looking at this quickly…
Originally Posted by
njadvani
1. When updating 1st row on table. It updates on 1st row on sheet. But this just happens to 1st row on table.
try changing If rowToMatch > 1 Then to If rowToMatch >= 1 Then
Originally Posted by
njadvani
2. When updating time. The stop time and start time doesn't get populated on actual cells. They go empty on sheet.
In the cmdupdate_Click sub, the two lines which do that are:
.Cells(rowToMatch, "F").Value = dateVariable
.Cells(rowToMatch, "G").Value = dateVariable1
however, the variables dateVariable and dateVariable1 are both empty at that point (unlike the similar lines in the cmdsave_Click sub) so you need to make sure they contain the right data.