Macro to Update Table Row Data only if Not Blank

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!

Thank you very much, PCI and sintek! Both options worked exactly as I needed. I went with PCIs version since it correctly assumed that I need some validation to ensure that the user selects a name and enters a date.

PCI, for some reason the error message to alert the user to a missing update date is not working. Running the macro allows me to add the information to the Clothing table without a date, and if I do so, the date in the ClothingTable reverts to 01/00/1900. It looks like it should work so I am not sure why the alert is not showing.

sintek, that works perfectly! Thank you so much for replying so quickly with such an elegant solution. I really appreciate your help and expertise!

Oh wow, extra comma haha. Happens to the best of us; thanks for the follow-up PCI!