Calculate Missing Data and Fill

Hi All,

I maintain a workbook that I use to run a process at the end of each day. The workbook contains a macro that grabs prices for 11 products from another file on my company's shared drive. However, the process is only designed to run for the current day - if I went a week without running it, when I started back up again it wouldn't fill in the missing days.

What I'd like to do is create a macro to help facilitate this process. As you can see in the attached file, the data I already have is in descending chronological order. My thinking is as follows: on the "Dates" tab, I have a formula to calculate how many days worth of data I'm missing "X" (TODAY - the most recent date that I have). From there, if I could come up with something to insert that many rows ("X" rows) at row 10and then insert the correct dates in A, and then a formula in each cell from B - L (the formula pulls in the data in the actual workbook), I'd end up with whatever I was missing. I'm not sure if a loop of some sort is the most efficient way to do this. Fill Missing Data.xlsm

Any thoughts, suggestions, etc. are much appreciated. Thank you for taking a look!

Best,

Student1990

Yes - this works perfectly. Thank you for your help!