VBA copy and paste daily

[AliciaGoyanes]

Hello, how are you?
I am trying to find the way to build a code where each day, by running the code, I have a table of my PNL consolidation.

In cells L9 and L10 I have my "realized" and "unrealized pnl". This changes daily once I get connected in the morning, so I want to find a way in which every night, before leaving or once market is closed, I run the code so that a table is filled with these numbers.

To put the example:

L9 = REALIZED PNL	M9= 50000​
L10=UNREALIZED PNL	M10= 0​

in U column, starting in U3, I have a list of days, so that each day in the night I want in W3, W4, W5 to plug the value of realized and unrealized.

Could you give me a hand please?

Thank you so much

 

[AliciaGoyanes]

Hi, any help on this? I am trying to doing it by recording the macro but not really working as I will need an automatic way to copy and paste it one row below the day before.

Thank you in advance again.