Thank you,

1) I will try to put "Option Explicit" at the top of my module.
2) I set Automatic and later to Manual because inside the loop needs to be calculated before pasting the results to another sheet.
3) My goal is to reduce the time. For example, when I tried to run around 2,000 data, it took me 60 minutes to calculate and paste the results. I'd like to ask if there is a better way to loop the calculation part of the VBA and paste its specified (in this case "2020-12-31") results to another sheet?