Improving VBA Loop speed

Hello all,

I am trying to improve the speed of my loop macro because my loop macro is very slow to run a large database, over 3000 rows.
Is there any way to improve my loop macro? I have attached an example.

I would be appreciated with your help. Thanks.

Please Login or Register  to view this content.

1) Put Option Explicit at the top of your module and fix what needs fixing first. It will show when you run your code.
For instance, no use for "Dim TargetWB As Workbook" if it is not used anywhere.
2) You set Calculation to Automatic and later to Manual. Should that not be the other way around?
3) Explain in a concise manner what you want to achieve.

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?

Explain what needs to go where.
The macro should not be taking any time at all but we need to know what to do.