Macro to Update Table Row Data only if Not Blank

[applehugger]

In the attached workbook, on the Updates worksheet, the third column has a simple VLOOKUP formula that pulls clothing information from the Clothing worksheet.

I need a way to allow users to enter data into the fourth "New Values" column and update the relevant cell only if the cell in the "New Values" column is not blank. I also need the date in the "Date Updating" cell to override the Update Date in the relevant row in the Clothing worksheet.

Example:
-User selects "Jane Doe" from the list of residents. Jane's waist size has changed from 22 to 24, but nothing else has changed.
-User enters a date of 1/8/2024 in C3 (next to "Date Updating")
-User enters "24" for Jane's waist size in the cell next to her old waist size in the "New Values" column.
-User presses the "Update" button.
-On the Clothing worksheet, the value in the Waist Size column for Jane Doe is updated to 24, and the value in the Update Date column for Jane Doe is updated to 1/8/2024.

I really appreciate any help with this!