Create Userform entry utilizing predefined ID #

I watched a tutorial on how the attached file works and was created and such - and i can update it to match my needs. What I am needing to do though, is instead of having a unique ID #, is to utilize a predefined listing.

The user wants to have predefined dates in A2:A## (like what is listed below) already existing on the worksheet.... and then to be able to add / edit data based on what would be empty in column B

So... row two has 10/16 in column A, and whatever would be entered via the form. The next time that we run the macro and click "new" it would then look at 10/23/2023 as the ID number, and enter that information accordingly. Click new again? Then 10/30/2023 and so forth.

10/16/2023
10/23/2023
10/30/2023
11/6/2023
11/13/2023
11/20/2023
11/27/2023
12/4/2023
12/11/2023
12/18/2023
12/25/2023
1/1/2024
1/8/2024
1/15/2024
1/22/2024
1/29/2024
2/5/2024
2/12/2024
2/19/2024
2/26/2024
3/4/2024
3/11/2024
3/18/2024
3/25/2024

How do I update that ID field to match the numbers that would exist in the "date" column?

What happened to your below thread?

Transform data set to have Unique values in row, and references transposed to columns

Originally Posted by jindon

What happened to your below thread?

Transform data set to have Unique values in row, and references transposed to columns

Hi Jindon!

This was incredibly helpful and helped a lot. THank you!