Insert missing dates into a list of dates using vba

I have created a share price report using vba whereby column a has a list of dates and columns A, B, C, D etc have the price of stocks and shares on the date in column A. The dates on my report only come through for days where shares actually price.

I have been asked to produce the same report but include weekends and holidays where shares did not price. This is easy to do manually but I'm stumped using vba.

Basically I need every missing day to be included in the report and where the price cells are blank use the price from the previous day.

I've attached a spreadsheet showing what I currently have on my report and what I need it to look like.

Any help you could give me would be appreciated.

Thanks for your help JieJenn

I'm afraid I get a debug error straight away with

Dim wsData As Worksheet: Set wsData = ThisWorkbook.Worksheets("Data")

Just to clarify: The data in my spreadsheet would just be the first batch of data. The second set of data is just for illustration purposes as to how I would want the first set of data to end up looking.

I appreciate the help.

Thanks