Hello friends.

I would like to paste loop results in different sheet as follows.
Put current date in column B below last active row.
Put loop results below the current date.
I am able to do all of these 2 steps.
The issue is that I run the macro several times in the day and the loop will copy several times. I need a rewrite on current loop results for current date.

Part of the reason is that I am pasting the results under end row of B right after current date.
I am wondering how to reference current date row as input for the loop results. Instead of pasting onto last active row, I would like to paste under the specific row (current date).
Another way would be to clear rows under current date before pasting loop.

Please advise.
Thanks million.
Elf