Take date from string and input into varying column length

Book4.xlsx

Hi everyone, I have a report I could use some help with If anyone is up for it.

I can't figure out a way to make the column with start date take the date from the merged row, and then input it up until the next merged row. Keep in mind that there are two merged rows grouped together, so it would need to start after the second one.
Hopefully this could loop down until the end of the table, I've already defined Lastrow in my vba that i use on my real table (cant post that without getting in trouble).

Thanks for yalls help!

I have gotten to where if i input the formula =MID(A8,12,10) into the cell the date will show up, but i know this isnt the right way to do it.

EDIT: there are sometimes merged cells in the middle of the table, with the same start date through them! new attachment

Also: if you could include comments in your code so i can learn from it i would appreciate it

Hello bruizer31,

Do you want to copy the date from the merge cells down column "B" for each client?

Hello bruizer31,

I have added a button at the top of the sheet to run macro. Here is the code. The attached workbook has all the changes already added.

Please Login or Register  to view this content.