VBA copy and paste daily

AliciaGoyanes

New Member
Joined
Sep 29, 2022
Messages
12
Office Version
  1. 2021
Platform
  1. Windows
  2. MacOS
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
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

AliciaGoyanes

New Member
Joined
Sep 29, 2022
Messages
12
Office Version
  1. 2021
Platform
  1. Windows
  2. MacOS
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.
 

Forum statistics

Threads
1,181,165
Messages
5,928,471
Members
436,603
Latest member
regismaltais

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top