How to add new row each day automatically below current data.

[Hmill]

I wrote this VBA code to fill in missing data up to current date. The problem is that is fills it in above my current data, not below which messes up everything. How can I fix this?

This is table.

VBA Code

 

[Hmill]

So I have to put it in this highlighted one?

 

[Joe4]

Yes, that is correct.

 

[Hmill]

Awesome, thank you!

 

[Joe4]

You are welcome.
Glad I was able to help!